<div>
Ah, ok thanks. I thought I might be able to get away with a simple InputBox.<br />
Thanks for the advice<br />
Toco
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
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. <br />
<br />
How can I do this in my VBA code ?<br />
<br />
Thanks<br />
Toco
</div>
</div>


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 ?

Thanks
Toco

Ah, ok thanks. I thought I might be able to get away with a simple InputBox.
Thanks for the advice
Toco

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

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.