InputBox drop-down menu

[Etrnal168]

Hello guys:

I am wondering whether I could get some help here on some macros.

I am trying to write a macro that displays an inputbox, but instead of showing a blank field waiting for a value, I would like the blank field to become a drop down menu when you click on it, which will show all the possible values that can be entered into the field, and when you select that particular value, the value will be entered into the blank field.

Any ideas?

Thanks in advance.

-Thomas

[Gareth]

You cannot modify the InputBox. You need to make a userform and add a
listbox or combobox to it.

Check out Microsoft Forms in the VBA help. It's extensively covered.

Happy coding.

Gareth

Etrnal168 wrote:
> Hello guys:
>
> I am wondering whether I could get some help here on some macros.
>
> I am trying to write a macro that displays an inputbox, but instead of
> showing a blank field waiting for a value, I would like the blank field
> to become a drop down menu when you click on it, which will show all the
> possible values that can be entered into the field, and when you select
> that particular value, the value will be entered into the blank field.
>
> Any ideas?
>
> Thanks in advance.
>
> -Thomas
>
>

[Bob Phillips]

How about Data Validation? See http://www.rondebruin.nl/calendar.htm

--
HTH

Bob Phillips

"Etrnal168" <[email protected]> wrote
in message news:[email protected]...
>
> Hello guys:
>
> I am wondering whether I could get some help here on some macros.
>
> I am trying to write a macro that displays an inputbox, but instead of
> showing a blank field waiting for a value, I would like the blank field
> to become a drop down menu when you click on it, which will show all the
> possible values that can be entered into the field, and when you select
> that particular value, the value will be entered into the blank field.
>
> Any ideas?
>
> Thanks in advance.
>
> -Thomas
>
>
> --
> Etrnal168
> ------------------------------------------------------------------------
> Etrnal168's Profile:
http://www.excelforum.com/member.php...o&userid=25135
> View this thread: http://www.excelforum.com/showthread...hreadid=387041
>