Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I choose multiple values in an excel drop down box? | Excel Discussion (Misc queries) | |||
Drop down list with multiple choices | Excel Worksheet Functions | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
How to sum values in multiple worksheets | Excel Worksheet Functions | |||
Multiple X-Axis Values | Charts and Charting in Excel |