How do I display a drop-down list within my Excel VBA InputBox ?

Hi Experts,

I have an Excel VBA application which, on the click of a button, displays an InputBox with associated text label and user prompt. I want the InputBox to display as a dropdown list from which the user can select an option.

How can I do this in my VBA code ?

Who is Participating?
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
You need to use a form instead of an InputBox.
TocogroupAuthor Commented:
Ah, ok thanks. I thought I might be able to get away with a simple InputBox.
Thanks for the advice
All Courses

From novice to tech pro — start learning today.