Re: Code for Input Box

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Fred (onbekend_at_geenmail.nl)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 11:48:59 +0200

Hi Laura,

to my knowledge you cannot make a standard inputbox behave like a combobox.
I would use a user form with a combobox instead. I don't know what your
problems were with comboboxes yesterday, but this seems the only option to
me.

Good Luck

"Laura C" <anonymous@discussions.microsoft.com> wrote in message
news:22d3701c45dbb$2d437680$a501280a@phx.gbl...
> Hello.
>
> Help please?
> I asked a rather long winded question yesterday about
> Combo Boxes. What I think I'm going to have to try and do
> is use an input box. Can anyone offer any code on how to
> have a combo box or list within an input box. The user
> must select a category which is then filtered for viewing.
> So I don't want them typing anything but selecting? Is it
> possible?
>
> Cheers
> Laura

Relevant Pages

  • Combobox will not fill
    ... I am trying to fill a combobox in a user form ... Dim cName As Range ... Dim ws As Worksheet ...
    (microsoft.public.excel.programming)
  • Re: how do i add items in the drop down box using Visual basic?
    ... You can double click on the combobox. ... this code in the User Form Initialize event. ... Private Sub UserForm_Initialize ...
    (microsoft.public.word.vba.general)
  • refreshing ComboBox values
    ... I am having trouble refreshing a ComboBox on a UserForm. ... I have a user form with a combo box that is populated with ... the last selected option? ...
    (microsoft.public.excel.programming)
  • help on spinbutton controllinng a text or ComboBox showing time
    ... I need to have a TextBox on a user form that has an ... associated SpinButteon be able to show a time range of 0 to 8:00 in 15 ... I'm thinking that a ComboBox setting the List source to an array and ... using the SpinButton to move up or down the array would be the best/ ...
    (microsoft.public.excel.misc)
  • Re: ComboBox
    ... and yes I'm using a user form ... > on the worksheet, and set the Controlsource property to D4 to get the ... > (remove nothere from the email address if mailing direct) ... >> Can someone help me with populating a ComboBox with say ...
    (microsoft.public.excel.programming)