I believe you'd have to use a macro to get the result you want. The sheet's
change event handler would have to see if the first validation cell is the
one that triggered it and, if so, change the validation list of the second,
as well as its contents.

--
Jim Rech
Excel MVP
"jhollin1138" wrote in message
...
|I have a spreadsheet that has 2 Validation lists. The first list is to
| select an item for a group (example: animal, vegetable or mineral). The
| second list is dependant on the first list and displays options available
| for the selected group (example: animal is selected in list 1; cat,
monkey,
| horse, etc. is available in list 2). I have this part of the spreadsheet
| working, put when I change the selected item in list 1, list 2 still
| displays the last item selected prior to selecting a new item in
Validation
| list 1. Is there a way to refresh list 2 (or unselect the previously
| selected item), after list 1 is changed?
|
| TIA,
|
| ----------
| Jim H
|
|