display list selection in a different cell
in [General]
|
Prev: pulling from one sheet to another
Next: Joining Two formulas with the Help of AND / OR / IF Functions to get the desired result
From: notsomuchaguru on 27 Apr 2010 12:29 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
From: Jim Thomlinson on 27 Apr 2010 13:39 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
From: Jim Thomlinson on 27 Apr 2010 13:51
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 |