View Single Post
  #2 (permalink)  
Old June 5th, 2007, 10:14 AM
dartcoach dartcoach is offline
Friend of Wrox
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post

Your listbox values are indexed from 0. you have to loop thru them until you find the one that has been selected. This example shows with an index on the listbox.

   For I = 0 To Me.lstCheckOut.ListCount - 1
      If Me.LstCheckOut.Selected(I) = True Then
         MsgBox Me.LstCheckOut.Column(1, I)
      End If
   Next I

Hope this helps.