I think what you need is a dependent DV list.

Select Dog from DV list and a second DV list appears with the Type of dog

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Thu, 13 Jul 2006 08:57:02 -0700, Keith H <Keith
wrote:

I have a validation on one of my columns for Users to select values from a
list in a different worksheet. This works fine, but now the Users need to
select multiple values in the one cell. How do you do that? A simple
example.
Pet Type
Dog Retriever, Beagle