Excel - Conditional Lists

[DennisT]

I'm trying to make available lists conditional on prior cell entries. Example:

CellA1 Has a list where the user can pick from:
Fruit
Veggie
Bread
Pasta

When the user goes to CellA2 the list there is dependent upon what they entered in CellA1. IE
if they picked Fruit the list they see in CellA2 is
Bananna
Apple
Mango
if they picked Veggie they would see
squash
carrot
peas
corn

etc ...
Lists could change over time, IE peach is later added to the fruit list or Drink added to the CellA1 list.

Can this be done in the std interface or would it have to be done with VB?

TIA

 

[Anon_F]

Click HERE

 

[DennisT]

Thanks - That lead me to this post:

http://www.mrexcel.com/forum/showpost.php?p=126&postcount=4
which explained how to do it. The key is to ensure the defined Name for a range matches the field name in the prior list.