drop down boxes that rely on the first drop down box

[Zimmerman]

How can I create a drop down box that will look up the information from the first drop down box. So in cell a2 i have a drop down box that the user can pick from a list in cells b3:B8. Now i want to create another drop down box that only has the information needed that the first drop down box is related too. So just say that the user picked meat from the first one. Now i want the second one to pull a list of meats from a list. Or if they would pick fruits in the first one then i want the second one to pull a list of fruits.

Any help would be appreciated.
Windows XP
Excel 2003

 

[VoG]

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

 

[Zimmerman]

That should work. I'll see what i can do.

Thanks!

 

[Zimmerman]

Ok i keep looking at this and for more of an answer but here's my problem. My list boxes i need are more than one word list. How can I create a list box based off another list box that the list contain 2 or more words in them.