Drop-down lists

[hermunn123]

I have a sheet where I'm incorporating some drop-down lists but I'd also like the ability to overwrite that cell with whatever the user wants if the specific item isn't in there... I suppose it kind of defeats the purpose of the drop-down but I'm curious if there's a way to do that.

Thanks!

 

[texasalynn]

It allows you to type into the cell without selecting from the drop down

 

[hermunn123]

Right but when I try to type into a cell instead of using the drop down list, I get an error that says:

The value you entered is not valid.
A user has restricted values that can be entered into this cell.

 

[texasalynn]

ah then you also have a validation rule, sorry I'm not sure about that then

 

[poolhall]

hermunn123,

In Data Validation dialog, Error Alert tab, uncheck Show error alert after invalid data is entered option.

 

[hermunn123]

hermunn123,

In Data Validation dialog, Error Alert tab, uncheck Show error alert after invalid data is entered option.

Always something easy like that... thanks