Using data validation, you can select multiple items with some
programming. There's an example he

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Select Multiple Items from Dropdown List'


Debra Dalgleish wrote:
You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and he

http://www.contextures.com/xlDataVal01.html


Kristy wrote:

I'm hoping to create drop down boxes in a spreadsheet that can have
multiple values. I haven't been able to make this work and am
wondering if it's even possible.

Any help would be great, thanks!





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html