If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to sum values in multiple worksheets | Robert Lawrence | Worksheet Functions | 3 | January 29th, 2005 05:15 AM |
Multiple X-Axis Values | Rob Herrmann | Charts and Charting | 2 | January 23rd, 2005 10:57 PM |
Multiple Values in Drop-Down Box | kimneuen | Using Forms | 2 | September 24th, 2004 08:21 PM |
Multiple values in excel's vlookup | EXCELlently Confused | Worksheet Functions | 1 | January 27th, 2004 05:49 PM |
Looking up multiple values | Jason Morin | Worksheet Functions | 4 | January 22nd, 2004 05:37 PM |