Data Validation lists - entering value not in list

  • Thread starter Thread starter rgarber50
  • Start date Start date
R

rgarber50

I want to have an incell drop down list - but I also want to enter an
item not on the list. Most of the time the drop down list is fine -
once in a while I want to enter an item not on the list. Is there a way
to set up data validation to be able to do this?

This would be a list of text choices - the list does not consist of
values.


Thanks

Richard
 
In the data validation dialog box, on the Error Alert tab, remove the
check mark from 'Show error alert after invalid data is entered'
 
Debra

Thanks! I knew it was something easy and staring me right in the face!

Richar
 
You must log in or register to reply here.

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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation - List of unique values 2
Use word to associate an item in validation drop down list 2
Data validation list using filtered range 3
Adding to a data validation list 2
data - validation - list question 2
Data Validation List (Drop Down) Not Showing 2
Customise drop down list validation 3

Back
Top