Dropdown list question

[pennyrod]

How do I choose more than 1 value from a dropdown list? Is this possible?

For example if a, b, c etc are in the dropdown list, how do I choose a and
b so that the cell value will be a b?

 

[Roger Govier]

Hi

You can only do this if you have ab as one of your entries in the list e.g.
a,ab,ac,b,ba,bc,c,ca,cb

Regards

Roger Govier

 

[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'