View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default 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