iterate an unbound listbox

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

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
 
rocco said:
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?
Click to expand...


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