In the process of setting up the Data Validation in that cell, there is a
tab labeled "Error Alert". Click on that tab. You will then see the
statement ""Show error alert after invalid data is entered." with a checkbox
to the left. Uncheck that checkbox. Now the user will see the drop-down
list as before but he can enter something else if he wants to. HTH Otto
"Cyrus" wrote in message
...
I would like to creat a drop down list where user can select specified
text,
however, I would also like the user to type other entries. I don't
necessarily want to completly restirct data imput, but I want to make
easier
for user.


I've created an error message that explains to the user how to add their
entry to the list, but I'd like to make easier where they can either
select
from drop down list or enter their own entry.

Thanks

Cyrus