Inserting info in a drop down box

  • Thread starter Thread starter abumustapha
  • Start date Start date
A

abumustapha

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 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?
Click to expand...

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
 
Data>Validation>Error Alert.

Uncheck the option to "show error alert etc."


Gord Dibben MS Excel MVP
 

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

Filtered drop down list 2
Drop down list and macros? 1
Adding more options in a drop down list 4
Customise drop down list validation 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop down list 2
Data Validation List (Drop Down) Not Showing 2
Excel Drop down 7

Back
Top