How can I attach data to a validation drop-down box?

[Guest]

What I would like to do is have a drop-down box where I select an item and
have it populate the next drop-down box with data that relates to the former
box.

Example:
First drop-down has the entries breakfast,lunch,dinner,snack
2nd drop-down list would populate depending on your first choice: for
breakfast it would offer: cereal,ham-n-eggs,yogurt,fruit
3rd would relate if you chose fruit: banana,apple,orange,mango
so on and so forth.

Let me know if there is a way to do this.

Thanx!

 

[Rowan]

See this link:

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

Hope this helps
Rowan

 

[Guest]

Rowan,

Correct website, incorrect page for what I wanted. Now that I know the
correct name for what I want to do 'Dependant Drop-down list'. But you DID
direct me to where I needed to be.

Thank You!