Just disable the error alert.


Gord Dibben MS Excel MVP

On Wed, 2 Sep 2009 15:00:01 -0700,
wrote:

what in the rare occasion I want to type something besides the data
in the drop down list.
What I would like a word like "other" that you could select from
the drop down that would take away the validation from the cell.

I know that is way out there, but thought I would ask