Inserting info in a drop down box
 

I have created a drop down list . the validation data cell and the original
values are in different sheets,but on the same wirkbook. If I try to type in
new information that is not on the list it will give me an error message "The
value you entered is not valid". Is there a way to manually inpu information
in a drop down list?

Inserting info in a drop down box
 

On May 17, 12:24*pm, abumustapha
wrote:
I have created a drop down list . the validation data cell and the original
values are in different sheets,but on the same wirkbook. If I try to type in
new information that is not on the list it will give me an error message "The
value you entered is not valid". Is there a way to manually inpu information
in a drop down list?

I'm not sure i understand your question, but if you get an error from
putting in a value that is not on your list, then it sounds like you
need to update your list. In the validation settings, set your source
to your updated list.

Hope that helps
dk

Inserting info in a drop down box
 

DataValidationError Alert.

Uncheck the option to "show error alert etc."


Gord Dibben MS Excel MVP

On Sat, 17 May 2008 09:24:01 -0700, abumustapha
wrote:

I have created a drop down list . the validation data cell and the original
values are in different sheets,but on the same wirkbook. If I try to type in
new information that is not on the list it will give me an error message "The
value you entered is not valid". Is there a way to manually inpu information
in a drop down list?