looping through a list box

B

bbdobuddy

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
 
D

Dan Artuso

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.
 
Top