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

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" <[email protected]> wrote in message
news:[email protected]...
> 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,

Thanks a lot. I appreciate it.

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>
>