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
|