View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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