You can't do it with a drop down. You might be able to get by with a
ListBox, which does support multiple selections.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC www.cpearson.com
(email on web site)
Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.