Multicolumn ListBox

  • Thread starter Thread starter smoenra
  • Start date Start date
S

smoenra

How can I get the values from multiple columns of a selected item in
list box? For instance, if I select a persons first name in a listbo
and i have columns 2 and 3 hidden (0" length) how can I via using V
get the values of columns 2 and 3
 
Hi

As long as the ListBox is NOT set to MultiSelect, you can use

MsgBox ListBox1.List(1, 2)

For Column *3* value. With 0 (zero) being Column 1

You can also, depending on your needs, change the BoundColumn, 1 by
default , as this is what determines the Value Property.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Back
Top