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)".

--
Regards,
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility

wrote in message
...
Hi All,

I have listbox having six columns for each row.
I need to know which item is been selected ( six columns item ).