Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
How do I make a list box in a form that to the left of the list item there is
a check box or so that I can select multiple items in the list box? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
Hi,
In the vba window, select the listbox control and goto to the properties window, Find the MultiSselect property and choose as appropriate. Regards Jean-Yves "ranswrt" wrote in message ... How do I make a list box in a form that to the left of the list item there is a check box or so that I can select multiple items in the list box? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
Thanks That was easy.
How do I capture the items that are selected? "Jean-Yves TFELT" wrote: Hi, In the vba window, select the listbox control and goto to the properties window, Find the MultiSselect property and choose as appropriate. Regards Jean-Yves "ranswrt" wrote in message ... How do I make a list box in a form that to the left of the list item there is a check box or so that I can select multiple items in the list box? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
Set up a loop to iterate through the entries on the listbox and check
to see which ones have .selected = true. hth Keith |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
Use more the VBA help for all the control properties or method
Once your cursor is in the MultiSelect property, press F1, and select example. -- Regards Jean-Yves Tfelt Europe "ranswrt" wrote: Thanks That was easy. How do I capture the items that are selected? "Jean-Yves TFELT" wrote: Hi, In the vba window, select the listbox control and goto to the properties window, Find the MultiSselect property and choose as appropriate. Regards Jean-Yves "ranswrt" wrote in message ... How do I make a list box in a form that to the left of the list item there is a check box or so that I can select multiple items in the list box? Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
How is the best way to loop thru the entries?
"Keith74" wrote: Set up a loop to iterate through the entries on the listbox and check to see which ones have .selected = true. hth Keith |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
Please read the help file
For i = 0 To ListBox1.ListCount - 1 If ListBox1.Selected(i) = True Then msgbox "selected value I : " & ListBox1.List(i) End if Next i -- Regards Jean-Yves Tfelt Europe "ranswrt" wrote: How is the best way to loop thru the entries? "Keith74" wrote: Set up a loop to iterate through the entries on the listbox and check to see which ones have .selected = true. hth Keith |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
Thanks
"Jean-Yves" wrote: Please read the help file For i = 0 To ListBox1.ListCount - 1 If ListBox1.Selected(i) = True Then msgbox "selected value I : " & ListBox1.List(i) End if Next i -- Regards Jean-Yves Tfelt Europe "ranswrt" wrote: How is the best way to loop thru the entries? "Keith74" wrote: Set up a loop to iterate through the entries on the listbox and check to see which ones have .selected = true. hth Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |