Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting selected listbox values
i set multiselect property of listbox control to fmMultiSelectExtended. by the way, i want to get the selected list names. the following code...?? for i = 0 to listbox1.listcount - 1 if listbox1.list(listbox1.listindex).selected then msgbox listbox1.list(listbox1.listindex) endif next *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting selected listbox values
Hi X Taol,
Try: '============= Private Sub CommandButton1_Click() Dim i As Long For i = 0 To ListBox1.ListCount - 1 If ListBox1.Selected(i) = True Then MsgBox ListBox1.List(i) End If Next i End Sub '<<============= --- Regards, Norman "x taol" wrote in message ... i set multiselect property of listbox control to fmMultiSelectExtended. by the way, i want to get the selected list names. the following code...?? for i = 0 to listbox1.listcount - 1 if listbox1.list(listbox1.listindex).selected then msgbox listbox1.list(listbox1.listindex) endif next *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set the selected state of an embedded ActiveX listbox | Excel Discussion (Misc queries) | |||
How to add selected row into listbox? | Excel Programming | |||
ListBox Selected Items into an Array | Excel Programming | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming | |||
Transposing a rng selected from a listbox | Excel Programming |