Possible to create multiple-selection drop-down box in Excel?

[Guest]

I've created a drop-down box in a spreadsheet and want to know if it's
possible to select more than one entry at once.

I have a list of manufacturers (i.e., Sony, Panasonic and NEC) with the
intention of having our resellers choose the manufacturers they use. For
research purposes, it is important that we capture the entire breadth of
their selection.

Suggestions?

 

[Debra Dalgleish]

You can do this with a data validation dropdown list and programming.
There's an example here:

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

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

 

[Colass]

Hi, I'm new with Excel Validation form and I've tried the 'DV0017 - Select Multiple Items from Dropdown List' and it doesn't work for me. Single item drop down works great but not the multiple choices. I'm working with excel 2000. Any ideas why?? Is it because I'm using Excel 2000?

Thank you