| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display list selection in a different cell
I have a combo list which is allows multiple selection.
I need to be able to display the selection in a different cell. For multiple selections, I'd like all values in one cell separated by commas. Example Combo list A B C D A & D have beeen selected. Displayed in another cell: A, D Please note I am using Excel 2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display list selection in a different cell
There is no built in function to do that but if you are not averse to macros
this will do it for you... Placed in a standard code module Public Function MakeCSV(ByVal rng As Range) As String MakeCSV = Join(Application.Transpose(rng.Value), ", ") End Function Which you can use in a worksheet like this =MakeCSV(A1:A10) -- HTH... Jim Thomlinson "notsomuchaguru" wrote: I have a combo list which is allows multiple selection. I need to be able to display the selection in a different cell. For multiple selections, I'd like all values in one cell separated by commas. Example Combo list A B C D A & D have beeen selected. Displayed in another cell: A, D Please note I am using Excel 2003 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display list selection in a different cell
Sorry I missread your question. That is not what you want. Do you have a
combo box or a list box? Did you get the control from the forms toolbar or the control toolbox? The only way to get values out of a multiselect is with code. There is nothing built in to do it... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: There is no built in function to do that but if you are not averse to macros this will do it for you... Placed in a standard code module Public Function MakeCSV(ByVal rng As Range) As String MakeCSV = Join(Application.Transpose(rng.Value), ", ") End Function Which you can use in a worksheet like this =MakeCSV(A1:A10) -- HTH... Jim Thomlinson "notsomuchaguru" wrote: I have a combo list which is allows multiple selection. I need to be able to display the selection in a different cell. For multiple selections, I'd like all values in one cell separated by commas. Example Combo list A B C D A & D have beeen selected. Displayed in another cell: A, D Please note I am using Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display part of list dependant on Validation list selection | Excel Worksheet Functions | |||
| Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
| Updating a cell from a list selection | Excel Worksheet Functions | |||
| Selection of Drop down list that allows you to go to a particular cell | Excel Worksheet Functions | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Hybrid Mode
