How do I choose multiple values in a drop down box?
 

I'm hoping to create drop down boxes in a spreadsheet that can have multiple
values. I haven't been able to make this work and am wondering if it's even
possible.

Any help would be great, thanks!

You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and he

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


Kristy wrote:
I'm hoping to create drop down boxes in a spreadsheet that can have multiple
values. I haven't been able to make this work and am wondering if it's even
possible.

Any help would be great, thanks!



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

Hi Kristy,

If you are trying to enable selection of more than one item, (for say, VBA
purposes), you might be better off with a List box.

For a simple data validation type drop down box, just go to Data
Validation, and choose "List2 fomr the drop down box, and point the source
to the list you want to use to populate this drop down box. This will lock
down the values allowed in that cell. You can also type the values directly
in to the source box - value1; value2; value3 etc.

Hope this helps

Sunil Jayakumar




"Kristy" wrote in message
...
I'm hoping to create drop down boxes in a spreadsheet that can have
multiple
values. I haven't been able to make this work and am wondering if it's
even
possible.

Any help would be great, thanks!

www.ayyoo.com

Using data validation, you can select multiple items with some
programming. There's an example he

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

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


Debra Dalgleish wrote:
You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and he

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


Kristy wrote:

I'm hoping to create drop down boxes in a spreadsheet that can have
multiple values. I haven't been able to make this work and am
wondering if it's even possible.

Any help would be great, thanks!





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