Drop down list with free text feature?

[Mike]

I know how to use data validation to make a drop down list. I did this to
make things easier for my coworkers to do our "OnCall" list. However, I need
to be able to make it so they can also type stuff into the boxes as well.
For example, My Cardiology dropdown has all of our Cardiologists in it.
Everynow and again we have some off the wall MD cover. I need to be able to
put that MD into the box without adding them to the Validation. Is there a
way to do this? So far everything I try just tells me that I can't because
of the validation list.

 

[T. Valko]

Disable the error message:

Select the cell with the drop down
Goto the menu Data>Validation>Error alert tab
Uncheck: Show error alert.....
OK

 

[Mike]

Thanks, I feel stupid. I thought I tried that but guess not.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks, I feel stupid. I thought I tried that but guess not.