creating drop down lists where you can select multiple values

[Guest]

Hi there

I want to create drop down lists in an excel spreadsheet that allow me to
select more than one value to be displayed in the cell.

Does anyone know how to help me?

Thanks in advance

 

[Debra Dalgleish]

You can do this with programming. There's a sample file here:

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

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

 

[Gord Dibben]

Angella

Check Debra Dalgleish's site for all you need to know about Data Validation
in-cell drop-downs.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben Excel MVP