+ Reply to Thread
Results 1 to 3 of 3

Change next ComboBox list based on previous ComboBox selection

  1. #1
    Registered User
    Join Date
    11-18-2014
    Location
    Uganda
    MS-Off Ver
    2013
    Posts
    25

    Question Change next ComboBox list based on previous ComboBox selection

    Hi Team,

    Problem: I have a userform with 2 comboboxes which obviously call a specific dynamic lists

    Trying to achieve: For example, the 1st comboxboxe is a list of school's. When a user selects a particular school from the 1st combobox, then in the 2nd combobox, I would like for it to only display the course's availbale for that particular school.

    What I have done so far: I have searched the heavens for an anwser that I would understand, but can't seem to get it right.

    Any help will be greatly appreciated and let me know if further information is required.

    Many Thanks

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Change next ComboBox list based on previous ComboBox selection

    Hey Steve,

    Look for Cascading Combobox like:
    http://mauriceausum.com/2011/08/01/c...excel-part-ii/ parts 1 and 2
    or
    http://chandoo.org/wp/2014/02/13/dyn...ns-that-reset/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    11-18-2014
    Location
    Uganda
    MS-Off Ver
    2013
    Posts
    25

    Re: Change next ComboBox list based on previous ComboBox selection

    Exactly what I looking for MarvinP, thank you mate

+ 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. Populating Combobox based on Combobox selection from EXCEL worksheet
    By JChaney17 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-04-2014, 08:14 AM
  2. Userform Combobox to populate based on selection in another combobox
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2014, 03:34 PM
  3. [SOLVED] Filter Combobox base on selection from previous combobox
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2013, 07:25 PM
  4. [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
  5. 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

Tags for this Thread

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