Solved: Data Validation Macro Problem

[JGalper]

p45cal -
What I ended up doing was reverting back to your original code and starting over to see if I can work around the problems. I found an alternate way to create a toolbar (I don't want to deal with tbarpos!!!) to add this as a toolbar button instead of the activex control.

Regardless of that, the problem appears to start when running the macro. When I type in a date it knows that it is in the list and pops up with the form, but when I manually start the macro, it appears to start checking the cells and giving me the error if they are NOT in the list. The only thing I can think of is that I tell the toolbar button to run the macro "CheckColumnC" when clicked, which may cause it to try and match the cells with the list, instead the opposite, which is the intended function.

Edit: Updated error function