Selecting Multiple Values from Drop Down

[tara_922]

Hiya all!

I'm not entirely sure this is possible with data validation...actually I'm fairly confident it's not. But am hoping one of you magicians will pull a rabbit out of your hat for me

Thanks in advance,
Tara

 

[wigi]

No.

You could make a userform with a listbox (that is MultiSelect). Or a RefEdit control to select cells in the sheet.
Or have an event procedure to let the users click or double click cells with their options.
Or have a number of inputboxes where the user types in a number or text or whatever.
...

But all require VBA if you want to streamline this. (Of course it's possible to let the user or you put 1's next to each choice, but that's not really an elegant solution I guess. Will also be hard to process the choices afterwards.)

 

[tara_922]

Okay, I was thinking it would be something like that. Thanks for the input and so quickly! I appreciate it!

Tara