Solved: Using 2nd value of listbox

[Charlize]

With [VBA]userform1.listbox1.value[/VBA] you can get the value of the first column in a listbox.
How can I use the 2nd or third value of a row in a listbox.

Something like [VBA]userform1.listbox1.item(2).value[/VBA]. This refers to column no2 of the row that was selected in the listbox.

Needed for duplicate items in the first column. I can't use a vlookup for the rest of the info because of this.

[Bob Phillips]

If you mean multiple selections

[vba]


With Me.ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) Then
Msgbox .List(i)
End If
Next i
End With
[/vba]

[geekgirlau]

If you want the second column,

[VBA]

userform1.listbox1.Column(1)

[/VBA]

[Charlize]

If you want the second column,


[vba]

userform1.listbox1.Column(1)
[/vba]

Thanks !!!

Charlize