Retrieving the value in 2nd column of List Box

[mp3909]

This is how I go about in retrieving the value in the first column of a list box that has column count = 2

For i = 0 To Me.Controls("lstBox").ListCount - 1
     debug.print Me.Controls("lstBox").ItemData(i)
Next i

I want to retrieve the value in the 2nd column and I tried doing this:

For i = 0 To Me.Controls("lstBox").ListCount - 1
     debug.print Me.Controls("lstBox").ItemData(i,2)
Next i

but I get an error saying "Wrong number of arguments or invalid property assignment"

[CJ_London]

columns are indexed from zero so first column is .column(0), second column is .column(1)

[mp3909]

So how should the final code look like then?

I tried doing this:

For i = 0 To Me.Controls("lstBox").ListCount - 1
     debug.print Me.Controls("lstBox").ItemData(i, .column(1))
Next i

and this:

 For i = 0 To Me.Controls("lstBox").ListCount - 1
debug.print Me.Controls("lstBox").column(1).ItemData(i)
 Next i

none of them work.

[CJ_London]

For i = 0 To lstBox.ListCount - 1

debug.print lstBox.ItemData(I,1)

next i

[CJ_London]

or perhaps

debug.print lstBox.ItemData(I).column(1)

[mp3909]

tried as per your suggestions and not working, get an error

[CJ_London]

get an error

how does that statement help me to help you?

[mp3909]

For i = 0 To lstBox.ListCount - 1

debug.print lstBox.ItemData(I,1)

next i

Run-time error '450'
Wrong number of arguments or invalid property assignment

[mp3909]

or perhaps

debug.print lstBox.ItemData(I).column(1)

Run-time error 424
Object required

[CJ_London]

suggest take a look at this link

https://stackoverflow.com/questions/...access-listbox