Hi C,

See Debra Dalgleish's Dependent List, Data Validation page at:

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



---
Regards,
Norman



"c" wrote in message
...
Greetings;
I am curious if any one out there knows how to the hide the values in a
dropdown list. What I want to do is choose an entry from a list and based
on
the choice a different drop down list will show up in the same cell. I
know
how to create drop down lists that are dependant upon a previous selection
(INDIRECT) but is it possible to do this all in the same cell. Or will I
have to use two cells and format the first so the data is hidden?