List Box - MultiSelect
 

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

List Box - MultiSelect
 

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" wrote in message
...
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

List Box - MultiSelect
 

Bob,

Thanks a lot. I appreciate it.

"Bob Phillips" wrote in message
...
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" wrote in message
...
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