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.
Bookmarks