Results 1 to 4 of 4

Thread: ListBox control in VBA Access

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    ListBox control in VBA Access

    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

  2. #2
    Super Moderator manavo11's Avatar
    Join Date
    Nov 2002
    Location
    Around the corner from si_the_geek
    Posts
    7,171

    Re: ListBox control in VBA Access

    To see which items are selected you can use this :

    VB Code:
    1. Dim i As Integer
    2.    
    3.     For i = 0 To List1.ListCount - 1
    4.         If List1.Selected(i) = True Then
    5.             MsgBox List1.List(i)
    6.         End If
    7.     Next


    Has someone helped you? Then you can Rate their helpful post.

  3. #3

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    Re: ListBox control in VBA Access

    Thanks manav...that worked great!!!!

  4. #4
    Super Moderator manavo11's Avatar
    Join Date
    Nov 2002
    Location
    Around the corner from si_the_geek
    Posts
    7,171

    Re: ListBox control in VBA Access

    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


    Has someone helped you? Then you can Rate their helpful post.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width