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.