Using Data Validation - how do I allow other entries

G

Guest

I've tried a few different settings for the Data Validation Column, and I
have been unable to allow entry of other items into the Column. I've got a
number of "Subjects" that are being used and with Data Validation I created a
pull-down list to use withn that column. However, I want to be able to add a
subject that is not in the pull-down list and I'm getting an error saying
it's not permitted.

How do I allow for subjects that are not in the pull-down - without having
to add them to the list?
 
B

Bernie Deitrick

On the third tab of the data validation dialog box ("Error Alert"), uncheck the box "Show error
alert after involid data is entered"

HTH,
Bernie
MS Excel MVP
 
G

Guest

That worked!
--
Thanks,
Diane


Bernie Deitrick said:
On the third tab of the data validation dialog box ("Error Alert"), uncheck the box "Show error alert after invalid data is entered"

HTH,
Bernie
MS Excel MVP
Click to expand...
 
G

Guest

Sorry, I didn't mean it to sound that way.....thought I had already tried
everything.
I was more "excited" than surprised that it worked.
:)
 

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

data validation for a single text entry 8
Excel 2007-programming macros that apply to data validation 1
Data Validation List (conditional) 2
Data Validation mystery 2
Data Validation 1
How do I get a Data validation list to select another validation l 1
Data Validation 1
Data Validation to exclude blank cells 6

Top