Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List Box - Multi Select Issue
Hello everyone, I was able to create a List Box per the site below and link
the data to the chart and got it to disply in cell A20 when i click on any item but I need the Multi Select option to work. So going off the exact example as it is a test, Simply, what I need is How To the Link cell A20 to display anything selected in the list box in once cell (note, I did set the list box propertys to linked cell A20 and can see only 1 item in the list when set to singel). Can anyone please help? http://support.microsoft.com/kb/291073 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List Box - Multi Select Issue
I just wanted to clarify that the list box i am using is an object like the
combo box, that is what i am working with, "Joe Wildman" wrote: Hello everyone, I was able to create a List Box per the site below and link the data to the chart and got it to disply in cell A20 when i click on any item but I need the Multi Select option to work. So going off the exact example as it is a test, Simply, what I need is How To the Link cell A20 to display anything selected in the list box in once cell (note, I did set the list box propertys to linked cell A20 and can see only 1 item in the list when set to singel). Can anyone please help? http://support.microsoft.com/kb/291073 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List Box - Multi Select Issue
Never mind, i got it
Private Sub ListBox1_Change() Dim outString As String, i As Long outString = vbNullString With ListBox1 For i = 0 To .ListCount - 1 If .Selected(i) Then outString = outString & ", " & .List(i) Next i End With Range("A1").Value = outString End Sub "Joe Wildman" wrote: I just wanted to clarify that the list box i am using is an object like the combo box, that is what i am working with, "Joe Wildman" wrote: Hello everyone, I was able to create a List Box per the site below and link the data to the chart and got it to disply in cell A20 when i click on any item but I need the Multi Select option to work. So going off the exact example as it is a test, Simply, what I need is How To the Link cell A20 to display anything selected in the list box in once cell (note, I did set the list box propertys to linked cell A20 and can see only 1 item in the list when set to singel). Can anyone please help? http://support.microsoft.com/kb/291073 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to select a multi value from a drop down box | Excel Discussion (Misc queries) | |||
Multi-select from drop down list in Excel 97 | Excel Discussion (Misc queries) | |||
how do I select multi values from a list | Excel Discussion (Misc queries) | |||
List Box Multi Select Option | Excel Worksheet Functions | |||
excel- multi level select from a list in excel? | Setting up and Configuration of Excel |