Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

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 ?

Thanks
Toco
0
Tocogroup
Asked:
Tocogroup
1 Solution
 
Phillip BurtonCommented:
You need to use a form instead of an InputBox.
0
 
TocogroupAuthor Commented:
Ah, ok thanks. I thought I might be able to get away with a simple InputBox.
Thanks for the advice
Toco
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now