Drilling down data using userform and listboxes

[hockeyman99j]

Hey hoping someone can help...

I have a userform that is pictured below...

In the first listbox i have it generate a static list with the same data.. no issues there...

I want the second listbox to only display ranges that are related to what is selected in the first listbox. I.e. the user clicks gatorade and also powerade in list box 1...i want list box2 to automatically display the named range gatorade and powerade for example sheet1!AF2:AF10 which i have named "Gatorade". then list box three will list the colors which is also in another list.

how would i go about the code for something like this..

thanks in advance

 

[hockeyman99j]

Bump..