Thread: listbox
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
ranswrt ranswrt is offline
external usenet poster
 
Posts: 191
Default 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