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


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