+ Reply to Thread
Results 1 to 2 of 2

Dynamically change list in a userform

  1. #1
    Forum Contributor
    Join Date
    04-13-2006
    Location
    London
    Posts
    102

    Question Dynamically change list in a userform

    I have a list that is loaded into my userform.

    When an item in the list is selected in a drop-down box, I would then like the userform to load a second list into a second drop-down box, depending on which item was selected in the first list.

    For example, the first list in the first drop-down could be:

    Fruit
    Vegetable
    Alcohol
    Squash

    So, if you were to select Fruit in the first drop-down, the second drop-down needs to load the fruit list, ie:

    Apple
    Lemon
    Lime
    Strawberry

    Conversely, if you were to select Vegetable, the drop-down needs to load the Vegetable list, ie:

    Carrot
    Potato
    Pea
    Corn

    What would be the appropriate technique?

    Thanks for any help in advance.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Cumberland,

    This link may give you some ideas that you can use...

    http://www.contextures.com/xlDataVal13.html

    Sincerely,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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