listbox

[ranswrt]

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

 

[ranswrt]

Thanks That was easy.

How do I capture the items that are selected?

 

[Keith74]

Set up a loop to iterate through the entries on the listbox and check
to see which ones have .selected = true.

hth

Keith

 

[Jean-Yves]

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.

 

[ranswrt]

How is the best way to loop thru the entries?

 

[Jean-Yves]

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

 

[ranswrt]

Thanks

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