Input Box Drop-Down List

  • Thread starter Thread starter Chris Morgan
  • Start date Start date
C

Chris Morgan

I have an input box for the user to enter a piece of data,
which is assigned to a particular variable, and in turn
entered into a particular cell. The data input into the
box, however, must be one of only a certain list of
values. Am I able to create a drop-down list within the
InputBox in order for only these particular values to be
allowed to be input?

Many thanks in advance,

Chris
 
No, you would need to create a userform with a combobox to get that
functionality.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input Box w/Drop Down List 4
EXCEL DROP DOWN 2
InputBox entries & advice 16
Default data in an input box 1
Input Box Q 3
using a conditional formula from a drop down list and If Statement 8
input box prompt 1
Drop-down list and error message 1

Back
Top