Selected listbox item

  • Thread starter Thread starter fi.or.jp.de
  • Start date Start date
F

fi.or.jp.de

Hi All,

I have listbox having six columns for each row.
I need to know which item is been selected ( six columns item ).
 
Use List Index. You can only select one row so you can't tell which column
that is selected. This doesn't work with multi-select option. The index
number starts with zero.
 
Another way is to use the Selected property, which works for all MultiSelect
settings, whether Single, Multi or Extended.

Dim n As Long
With Me.ListBox1
For n = 0 To .ListCount - 1
If .Selected(n) = True Then
MsgBox .List(n, 0) ' First column, selected row(s)
End If
Next
End With

The List property is zero-based, so List(n,0) is the 1st column, List(n,1)
is the 2nd column. The row selection is zero-based too, so List(1,0) is the
2nd row, 1st column. Read more about this in VBA help: "List Property
(Forms)" and "Selected Property (Forms)".
 
Back
Top