looping through a list box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,

I want to loop through the rows of a list box and get the values from
certain columns. I am trying to use the column property but I don't know
what the second parameter is looking for. I tried an int but it doesn't like
that. Any help that you could give would be great.

Thanks
bbdobuddy
 
Hi,
Here you go:

Dim i As Integer
For i = 0 To Me.lst1.ListCount - 1
MsgBox Me.lst1.Column(0, i)
Next

Just change the column to whatever one you want.
 
Back
Top