Inputbox with a drop down?

[Guest]

I have a VBA inputbox, but I don't want the user to type free text when
prompted. How can I make the VBA inputbox and drop down? The drop down items
are found in the workbook in the range A25:A36

 

[JW]

To my knowledge, this can not be done with a standard InputBox. Just
create a simple user form that looks like an Inputbox. Place a
ComboBox control on it and use the .AddItem method to add the items in
you range to the combo box when the form is initialized.

 

[RB Smissaert]

You might be interested in a custom messagebox I wrote in VB6:
http://shorterlink.com/?6JNRW1

Amongst many others it has the option to present a list of items that can be
picked by a right-click.
Your 12 or so items will be OK for that.

RBS