How do I make a drop down list pull up a specific list.

[DidDoThat]

Basically I need to display a specific table when a specific word appears in my drop down list.

I already have the dependent lists set up where as you pick a specific word from the drop down, and the next drop down only brings up choices relating to this word. To make this easier on the end user, I wish to have all the choices for the second drop down displayed at one time , as opposed to having a drop down menu with the choices, but I need them to change when ever you make a different selection. I need to get this working within the constraints of just Excel for right now, and then I will work on it with VB. Any suggestions would be greatly appreciated.

IE (This is what it looks like now)

Drop Down>(Fruit,Vegetables) And when you select Fruit you get the following

Drop Down>(Apples, Grapes, Oranges)

I need it to function like this

Drop Down>(Fruit,Vegetables) And when you select Fruit you get the following

Apples
Grapes
Oranges

and then when you use the Vegetable drop down menu it changes to

Peas
Corn
etc
etc.


Does this make sense? What am I doing wrong?

Thanks

 

[erik.van.geit]

Hi, Eric,

Depends how you have set up the thing...
I take vacation now, so suggest you start your own thread (and refer to here if you want)

kind regards,
Erik