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

[Kristy]

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]

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

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

 

[Sunil Jayakumar]

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

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

 

[Debra Dalgleish]

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

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

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