PDA

Click to See Complete Forum and Search --> : ListBox control in VBA Access


blakemckenna
Jun 7th, 2005, 02:57 PM
I am using the ListBox control in a VBA Access application. It's the first time to and I am a little confused. I have the "multi select" property set to true. How can I determine if a user clicks on a several values and then changes there mind and deselects them. Is there a way to determine this?

Thanks,

Blake

manavo11
Jun 7th, 2005, 03:01 PM
To see which items are selected you can use this :

Dim i As Integer

For i = 0 To List1.ListCount - 1
If List1.Selected(i) = True Then
MsgBox List1.List(i)
End If
Next

blakemckenna
Jun 7th, 2005, 04:23 PM
Thanks manav...that worked great!!!!

manavo11
Jun 8th, 2005, 03:28 PM
You're welcome :)

If your question is answered you can edit your first post and add [Resolved] to the thread. Also, we use the green checkmark as (as a post's icon) to indicate that the thread is resolved.

Thanks