How do I display a drop-down list within my Excel VBA InputBox ?
Posted on 2014-11-11
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 ?