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?

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


pennyrod wrote:
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?

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

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

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



pennyrod wrote:
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?




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