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" <whmc2@ix.netcom.com> wrote in message
news:uYO2av9BFHA.4092@TK2MSFTNGP09.phx.gbl...
> 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" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OtH9Rz9BFHA.2380@tk2msftngp13.phx.gbl...
> 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" <whmc2@ix.netcom.com> wrote in message
> news:uYO2av9BFHA.4092@TK2MSFTNGP09.phx.gbl...
>> 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
>>
>>
>
>