drop down menu that allows for text to be entered

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.
 
L

Luke M

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'
 
T

T. Valko

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......
 
S

s.bryan

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.
 
S

s.bryan

This worked. I already knew how to do the validation but the trick was with
unchecking the "show alert" box.
Thanks!!
 
Top