InputBox Choice

[Pete]

Is it possible to have a listbox in the Inputbox option so the user
can choose the item required rather than typing the item himself.

thanks

Pete

 

[Jim Cone]

No, the built-in input boxes, dialog boxes, msgboxes cannot be customized.
They all (most) have options available, but you are limited to those options.

You can add a limited amount of text to an input box that listed choices.
Or you could in a msgbox response to an incorrect entry, list the acceptable entries.
Otherwise, you will need a userform with a listbox, label and OK/Cancel buttons.
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(free and commercial excel programs)




"Pete" <[email protected]>
wrote in message
news:98d690ac-c963-4833-8c34-68ed1d139722@c29g2000yqd.googlegroups.com...