Re: MultiColumn ComboBox Value set/display



I like Bob's idea of a nice listbox more and more.

Jim Zeeb wrote:
>
> The purpose of this comboBox control is to select one item from a list and
> store the value selected in Column 1 (Bound Column) in an Excel worksheet
> cell referenced by the .ControlSource property.
>
> I could simulate this by using a locked TextBox, linked using the onClick
> event of the comboBox. It just seems like there should be an easy way to
> set/display both columns in the comboBox without all this extra code.
>
> ...jz
>
> "Bob Phillips" wrote:
>
> > How about using a Listbox?
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Dave Peterson" <ec35720@xxxxxxxxxxxxxxxxx> wrote in message
> > news:42ACA331.4DE00076@xxxxxxxxxxxxxxxxxxxx
> > > 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
> >
> >
> >

--

Dave Peterson
.