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.
Aaron wrote:
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