Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
single-cell multiple entry with pull-down list?
Hello,
I've been scouring all the tutorials and forums to see if it's possible to have multiple entries in a single-cell with a pull-down list. For ex. the pull-down list is composed of: Object A, Object B, ..., Object X When I click on a cell with the data validation-List enabled, I currently have the option of choosing Object A OR Object B, etc. But I can't pick Object A, then input comma in the same cell, then select Object B in the same cell (i.e. in one cell, have "Object A, Object B, etc.") without the second selection wiping out the first one. Is this possible in Excel and how can I do this? Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
single-cell multiple entry with pull-down list?
It's not possible. You could have multiple columns and choose different ones
in each (with a formula in another column to concatenate them if necessary). "Wade" wrote in message ... Hello, I've been scouring all the tutorials and forums to see if it's possible to have multiple entries in a single-cell with a pull-down list. For ex. the pull-down list is composed of: Object A, Object B, ..., Object X When I click on a cell with the data validation-List enabled, I currently have the option of choosing Object A OR Object B, etc. But I can't pick Object A, then input comma in the same cell, then select Object B in the same cell (i.e. in one cell, have "Object A, Object B, etc.") without the second selection wiping out the first one. Is this possible in Excel and how can I do this? Thanks in advance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
single-cell multiple entry with pull-down list?
DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a
dropdown list; an event macro stores selections in adjacent cell, or in same cell. DataValMultiSelect.zip 18kb updated 22-Feb-07 This sample workbook can be downloaded from Debra Dalgleish's website. http://www.contextures.on.ca/excelfiles.html#DataVal Note: the multiple entries in one cell are comma-delimited as you wanted. Gord Dibben MS Excel MVP On Wed, 19 Dec 2007 07:57:04 -0800, Wade wrote: Hello, I've been scouring all the tutorials and forums to see if it's possible to have multiple entries in a single-cell with a pull-down list. For ex. the pull-down list is composed of: Object A, Object B, ..., Object X When I click on a cell with the data validation-List enabled, I currently have the option of choosing Object A OR Object B, etc. But I can't pick Object A, then input comma in the same cell, then select Object B in the same cell (i.e. in one cell, have "Object A, Object B, etc.") without the second selection wiping out the first one. Is this possible in Excel and how can I do this? Thanks in advance! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
single-cell multiple entry with pull-down list?
But it is possible through code Stephen.
See my resopnse to OP Gord Dibben MS Excel MVP On Wed, 19 Dec 2007 16:04:07 -0000, "Stephen" <none wrote: It's not possible. You could have multiple columns and choose different ones in each (with a formula in another column to concatenate them if necessary). "Wade" wrote in message ... Hello, I've been scouring all the tutorials and forums to see if it's possible to have multiple entries in a single-cell with a pull-down list. For ex. the pull-down list is composed of: Object A, Object B, ..., Object X When I click on a cell with the data validation-List enabled, I currently have the option of choosing Object A OR Object B, etc. But I can't pick Object A, then input comma in the same cell, then select Object B in the same cell (i.e. in one cell, have "Object A, Object B, etc.") without the second selection wiping out the first one. Is this possible in Excel and how can I do this? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating multiple cells from a single pull down | Excel Discussion (Misc queries) | |||
I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
Formula and Data Entry in a Single Cell | Excel Discussion (Misc queries) | |||
excel-convert list of 52 into a form with each entry on a single | Excel Discussion (Misc queries) | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) |