Thread: InputBox Choice
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default InputBox Choice

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"
wrote in message
...
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