List Box colums - and value retrieval

[questionit]

From a List Box, how to get value in 2nd column ?

If we do Listbox0.Value , then we get the selected value in the first column only. How can i get value in 2nd column ?


Thanks

[JKing]

You can use the following:

Me.List.Column(1, Me.List.ItemsSelected(0))
 

The first parameter is the position of the column you want. This starts at 0 so 0 would be 1 and 1 would be 2 etc.
The second parameter is the row and Me.List.ItemsSelected(0) points to the first row of the selected items. If you're using a multi-select just add a for loop to cycle through the selectedItems.

[questionit]

I have only these Column properties available for my listbox - I am using VBA

ColumnHidden
ColumnOrder
ColumnWidth

do you know how to do with VBA?

You can use the following:

Me.List.Column(1, Me.List.ItemsSelected(0))
 

The first parameter is the position of the column you want. This starts at 0 so 0 would be 1 and 1 would be 2 etc.
The second parameter is the row and Me.List.ItemsSelected(0) points to the first row of the selected items. If you're using a multi-select just add a for loop to cycle through the selectedItems.

[JKing]

I am also using VBA. The Column property is supported for both listboxes and combo boxes.