Multi Column Combo Box
 

using the columnwidth is the only way.

combobox1.List(combobox1.listindex,1) would give you the value of the
second column for the selected row.

--
Regards,
Tom Ogilvy

"Kevin" wrote in message
...
I'm building a very large multi-level menu (over 4K
possible choices) by linking a number of combo boxes
(i.e. the choices available in combobox2 are dependent on
the choice made in combobox1, etc.). I need to include
multiple columns in the lowest level combo box. The
questions I have a

Is there a better way to only display 2 of the five
columns in the combobox than by setting the width of
those I don't want to show to 0?

How do I refer to separate columns from the combobox
choice (i.e. I want to populate a cell with the value in
the third column of the combobox choice)? Using
comboboxX.Value returns 1 value. What is the syntax for
specifically referring to each of the other column values?

thanx