Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ). |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selected ListBox item to TextBox | Excel Programming | |||
Worksheet Listbox selected item? | Excel Programming | |||
Delete selected Item from listbox | Excel Programming | |||
How to get the index in VBA of the selected item in a ListBox | Excel Programming | |||
How to copy selected listbox item to sheet | Excel Programming |