You can do this with data validation and programming. There's a sample
file he

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

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

Nancy @ CHR wrote:
Hello --

We've got no problem in creating a list for a drop down box in Excel and
assigning the list to a cell, etc. but how can you set it so that you can
select multiple values? For example, if the drop down list includes
1,2,3,4,5,6 as possible values, how can I get it to allow me to select 1 and
3 or 1, 3, 5 and 6 all at once (like you would typically expect to do by
holding down the CTRL key while selecting each value)?

Your help will be much appreciated! :-)
Nancy


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html