Nothing selected in my list box?

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

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
 
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
 
Back
Top