View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Daniel.C[_2_] Daniel.C[_2_] is offline
external usenet poster
 
Posts: 105
Default Nothing selected in my list box?

Hi.
You should use :

With Sheet1.ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) Then
'code
End If
Next i
End With

HTH
Daniel

Hello, I need to find out if the user has selected anything in my
multi-select1 list box, I am currently using

If lbxHeadings.ListIndex = 0 Then

but that is true if nothing is selected or if only the first item is
selected.

If I set option base1 will that allow me to distinguish between nothing
selected and the first item?

Is there an easier way, as option-base1 will mean a rewrite of lots of my
values throughout too?
Thanks

Michelle