Hi C,

My apologies, I responded without absorbing your same cell scenario.

Fortunately, Debra was was not similarly inattentive,

---
Regards,
Norman



"Norman Jones" wrote in message
...
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?