Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find a value with multi-column, multi-record list | Excel Worksheet Functions | |||
match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
Multi Column Combo Box | Excel Programming | |||
Multi column combo box | Excel Programming | |||
Extract values from a multi-select multi-column list-box | Excel Programming |