How do I get values from both columns of 2-column list box

[laterdaysluke]

On my worksheet Data Entry, I have a 2 column controls list box valled lst_main, and I have bound the first column, so I can always get the first column's value using:

Please Login or Register  to view this content.

However I want to get both the first columns value and the second columns value. How can I do this? I imagine it would be something like:

Please Login or Register  to view this content.

Also, If i want to explicitly declare it, then how do I do so? dim lst_main as OLEObject?

[Leith Ross]

Hello laterdaysluke,

You need to use the List property to specify the row and column within the ListBox. The row and column both start at zero. ListIndex points to the row the user clicked.

Please Login or Register  to view this content.