+ Reply to Thread
Results 1 to 4 of 4

Filter Combobox base on selection from previous combobox

  1. #1
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Wisbech England
    MS-Off Ver
    Excel 2010
    Posts
    308

    Filter Combobox base on selection from previous combobox

    Hi Everyone.
    I am really hoping to get help here.

    I have created a course booking form which automatically calculated the total training cost and cost of any replacement if required.
    Everything works as it should (Please see the sample book) but as you can see I am using a data validation list which is a pain when you have to select from over 300 employees...
    What I would like to have is few combo boxes like the ones in a sample book which would filter the next combobox base on selection in previous combobox this way a Manager can select his area/department and select only people from his team rather that from all departments and choosing from over 300 people....
    In addition to this, once the name is selected I would like to have button that says "Nominate this Colleague for the Course" which will record the combo box content in the next empty cell.
    Thanks in advance.
    Dan
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Filter Combobox base on selection from previous combobox

    Hi

    You are on the wrong track.

    List boxes are not the best solution in this scenario.

    I would use a few list boxes and type in my search criteria. Eg: Stu phd smith

    so I am after phd students with the name smith.

    I would search the database for the name smith

    I would check that row for my next search criteria.

    If all the criteria are met then I would populate a list box. In your scenario I would use a multiselect list box.

    I would select the students that I want to add to the course

    and press an update command.

    It is quite easy to do.


    I created something like this last week.

    http://www.excelforum.com/excel-prog...ml#post3477758

    the data entry field is the range C8 to G12.

    one of the cells must contain at least three characters and that forms the basis of the search

    all other cells are optional.

    try it using smi for smith in one cell and bir for birmingham in any other cell.
    Last edited by mehmetcik; 11-17-2013 at 09:20 PM.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Filter Combobox base on selection from previous combobox

    Try then attached.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Filter Combobox base on selection from previous combobox

    ciapul12

    Thanks for the rep and if the problem is solved, mark the thread as "Solved".

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Make combobox list options dependant on selection in another combobox within a userform
    By Vladimir_Dobvchenko in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2013, 05:30 AM
  2. [SOLVED] fill combobox selection based on a selection from the first combobox
    By Monza in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2013, 07:34 PM
  3. Way to populate combobox rowsource based on previous combobox value
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-08-2012, 12:50 AM
  4. Import textfile base on combobox selection !
    By Petter120 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2012, 02:14 PM
  5. userform combobox rowsources chosen by heading match to previous comboxbox selection
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2009, 02:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1