List Box - MultiSelect

[Bill]

Hello,
I have a list box where a user can select multiple items. How do I figure
out which items are selected using VBA? I thought there was a selecteditem
property, but I don't seem to find it.

Thanks,

Bill

 

[Bob Phillips]

Hi Bill,
Here is some code as a starter


With Me.ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) Then
Msgbox .List(i)
End If
Next i
End With



--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bill]

Bob,

Thanks a lot. I appreciate it.

Hi Bill,
Here is some code as a starter


With Me.ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) Then
Msgbox .List(i)
End If
Next i
End With



--

HTH

RP
(remove nothere from the email address if mailing direct)