| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a multiselect drop down list
I have drop down lists in my worksheet - I now need to make multiple
selections in some cells (each separated by a semicolon). Thx. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a multiselect drop down list
Yve,
If you want to do that, they must be included in the list as options. Otherwise, use multiple cells and concatenate the values into one string. HTH, Bernie MS Excel MVP "Yve" wrote in message ... I have drop down lists in my worksheet - I now need to make multiple selections in some cells (each separated by a semicolon). Thx. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a multiselect drop down list
Download a sample workbook from Debra Dalgleish's site.
http://www.contextures.on.ca/excelfiles.html#DV0017 Note that you can have the selections in an adjacent cell or in the same cell. You will have to edit the delimiter in the event code. Change ", " to ";" Gord Dibben MS Excel MVP On Thu, 22 Jan 2009 05:08:02 -0800, Yve wrote: I have drop down lists in my worksheet - I now need to make multiple selections in some cells (each separated by a semicolon). Thx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create a drop list that | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Create a list in a drop down dependent upon another dd list in exc | Excel Discussion (Misc queries) | |||
| create a drop down list | Excel Worksheet Functions | |||
| Can I create a drop-down list that will reference other drop-down | Excel Worksheet Functions | |||
Hybrid Mode
