with a drop down list in excel how do I select multiple values

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

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 [email protected]>
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