drop down menu that allows for text to be entered
 

I would like to be able to have a drop down menu of choices but also allow
others to enter text as well.
--
blsally04

drop down menu that allows for text to be entered
 

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'
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"s.bryan" wrote:

I would like to be able to have a drop down menu of choices but also allow
others to enter text as well.
--
blsally04

drop down menu that allows for text to be entered
 

Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

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

--
Biff
Microsoft Excel MVP


"s.bryan" wrote in message
...
I would like to be able to have a drop down menu of choices but also allow
others to enter text as well.
--
blsally04

drop down menu that allows for text to be entered
 

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


"Luke M" wrote:

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'
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"s.bryan" wrote:

I would like to be able to have a drop down menu of choices but also allow
others to enter text as well.
--
blsally04

drop down menu that allows for text to be entered
 

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


"T. Valko" wrote:

Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

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

--
Biff
Microsoft Excel MVP


"s.bryan" wrote in message
...
I would like to be able to have a drop down menu of choices but also allow
others to enter text as well.
--
blsally04

drop down menu that allows for text to be entered
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"s.bryan" wrote in message
...
This worked. I already knew how to do the validation but the trick was
with
unchecking the "show alert" box.
Thanks!!
--
blsally04


"T. Valko" wrote:

Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

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

--
Biff
Microsoft Excel MVP


"s.bryan" wrote in message
...
I would like to be able to have a drop down menu of choices but also
allow
others to enter text as well.
--
blsally04