MultiColumn ComboBox Value set/display
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
|