Hello
I’m looping through a list box returning the selected item, but is there a way to return the value of other columns in the list as I loop through the rows?
For Each ItemIndex In Me.myList.ItemsSelected
lngID = Me.myList.ItemData(ItemIndex) ‘Working okay
lngEmp = Me.myList.ItemData(ItemIndex,1) ‘Not working
Next
Thanks in advance.
I’m looping through a list box returning the selected item, but is there a way to return the value of other columns in the list as I loop through the rows?
For Each ItemIndex In Me.myList.ItemsSelected
lngID = Me.myList.ItemData(ItemIndex) ‘Working okay
lngEmp = Me.myList.ItemData(ItemIndex,1) ‘Not working
Next
Thanks in advance.