Cascading Drop Down Lists

  • Thread starter Thread starter Herb
  • Start date Start date
H

Herb

I have a list of categories and a secondary list of items associated with
each choice on the category list. I would like to be able to select a
category and then a selection from the secondary or dependent list but have
only that value show up in the column. There is only one column and I don't
want to display the category. All the examples I have seen would place the
category selection in column 1 and the dependent choice in column 2.
Any help would be much appreciated!
 
Herb
You can do that with VBA programming but an obvious problem is how do you
get the first list back? That too can be solved with VBA but you would have
to decide how you want that done. For instance:
When the file is opened or
When that sheet is activated or
When you click on some specific button or
Etc.
Post back if you want to pursue this further. HTH Otto
 
You could choose the category in a cell, then select from a dependent
list in the same cell. However, after you make that choice, you'd have
to clear the cell and start over, if you wanted to select a different
category or dependent item.

For example, in cell B2, you could select items from a list named
Produce. If you select Fruit, then the drop down in cell B2 would
change, to show a list of fruits.

To do this, in cell B2, enter this as the Data Validation formula:

=IF(B2="",Produce,INDIRECT(B2))
 
Back
Top