drop down menu that allows for text to be entered

  • Thread starter Thread starter s.bryan
  • Start date Start date
S

s.bryan

I would like to be able to have a drop down menu of choices but also allow
others to enter text as well.
 
Create a list of the values you want to suggest, and then add a cell witht
his formula
=A2 (where A2 is the cell you want dropdown to appear)
Select A2, Data validation, list, and select the list you created and
include the cell with formula.

If you want additional cells to have this same thing, simply expand your
list with more 'formula cells'
 
Watch this 5 min video:

How to setup a data validation drop down list:


To allow users to enter something that is not on the list disable the error
alert message.

On the Error Alert tab uncheck: Show error alert......
 
I tried it and even though it gives some blank spaces I still can't enter
anything in the box. What I want to do is have users be able to enter text
in the drop down menu. I'm guessing this isn't possible.
 
This worked. I already knew how to do the validation but the trick was with
unchecking the "show alert" box.
Thanks!!
 
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

Drop Down choice needs to lead to another drop down menu 1
Drop Down Menu Conditional Formatting 4
Drop Down list for entering data 1
Drop Down Boxes 2
Linking choices in drop down menu to have automatic answer... 3
Drop Down Menu 4
Drop Down Default 1
Customise drop down list validation 3

Back
Top