iterate an unbound listbox

[Guest]

Hello,
i would like to iterate on each row of an unbound listbox to retrieve values
for each of its columns.
Is that possible without having to select item by item?

Thanks
Rocco

 

[Marshall Barton]

i would like to iterate on each row of an unbound listbox to retrieve values
for each of its columns.
Is that possible without having to select item by item?

Check the Column proeprty in Help.

With Me.comboboxname
For J = 0 To .ListCount - 1
For K = 0 To .ColumnCount - 1
Debug.Print .Column(K.J)
Next K
Next J
End With