InputBox Choice
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 |
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 |
All times are GMT +1. The time now is 06:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com