Selected listbox item
Hi All,
I have listbox having six columns for each row. I need to know which item is been selected ( six columns item ). |
Selected listbox 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. " wrote: Hi All, I have listbox having six columns for each row. I need to know which item is been selected ( six columns item ). |
Selected listbox item
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 ). |
All times are GMT +1. The time now is 07:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com