You have a Data Validation list with items: apple, pear, peach, plum
You want the user to be able to select more than one in a single cell: apple
peach ?
Not possible or did I misunderstand the question?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Monica" wrote in message
...
How do I allow a multiple selection from a dropdown?
I know how to create a list / dropdown with multiple options but now the
question is - how can I choose more than one option?? I know that usually
it
works by pressing CTR, scrolling down the list and choosing mulitple
options.
But how do I apply it to the Excel worksheet?