MultiColumn ComboBox Value set/display
How about using a Listbox?
--
HTH
Bob Phillips
"Dave Peterson" wrote in message
...
I don't think you can.
You could concatenate the values:
Item1______Description1
so that you only have one column, but that may look kind of funny.
Maybe you could put a label right near the combobox that shows the other
column???
Jim Zeeb wrote:
I have a two-column ComboBox in a Form.
I am loading the choices via the .List = array
BoundColumn=1 updates a worksheet cell.
When I set the .Value or Choose an item from the pulldown, it only
displays
the first column.
How do I set the .Value for the second column and show both columns when
an
item is selected from the pulldown.
inTHANKSadvance,
Jim Zeeb
--
Dave Peterson
|