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