Input Box Drop-Down List
 

I have an input box for the user to enter a piece of data,
which is assigned to a particular variable, and in turn
entered into a particular cell. The data input into the
box, however, must be one of only a certain list of
values. Am I able to create a drop-down list within the
InputBox in order for only these particular values to be
allowed to be input?

Many thanks in advance,

Chris

Input Box Drop-Down List
 

No, you would need to create a userform with a combobox to get that
functionality.

--
Regards,
Tom Ogilvy

"Chris Morgan" wrote in message
...
I have an input box for the user to enter a piece of data,
which is assigned to a particular variable, and in turn
entered into a particular cell. The data input into the
box, however, must be one of only a certain list of
values. Am I able to create a drop-down list within the
InputBox in order for only these particular values to be
allowed to be input?

Many thanks in advance,

Chris