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
.

Relevant Pages

  • Re: Autofilters and Userforms
    ... value (via the dropdown from the Combobox) I would get a return from BI ... I notice to that with Autofilter there are only 2 ... Tom Ogilvy wrote: ... You would use John's code to fill the listbox. ...
    (microsoft.public.excel.programming)
  • Re: AutoComplete ComboBox Search on Substring for KeyPress
    ... AutoCompleteSource properties of the combobox, ... The second is a ListBox (mine is named ArtistNameList. ... list of strings and those strings will be bound to the listbox. ... Private Sub ArtistName_TextChanged(ByVal sender As System.Object, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: AutoComplete ComboBox Search on Substring for KeyPress
    ... Smith) and would like to go to the LAST name whenever a user presses a key while on this combobox. ... I have an implementation that uses a text box and a hidden listbox. ... The search will return a list of strings and those strings will be bound to the listbox. ... Private Sub ArtistName_TextChanged'Handles ArtistName.TextChanged ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Combo Boxes
    ... I wouldn't use a combobox for this. ... I'd use a listbox. ... Private Sub CommandButton2_Click ... Dim HowMany As Long ...
    (microsoft.public.excel.programming)
  • Re: Thank you, TOM OGLIVY: linking across the worksheets
    ... You can't really have a multiselect combobox and as you state, ... > listbox... ... > crew install 50 live oaks and 35 Yucca plants. ... >>>>> I have created a user form, ...
    (microsoft.public.excel.programming)