Yes, Aflatoon, I felt it was over engineering as well. The problem is that cell level data validation dropdowns do not look any different than other cells, so to show the user what to do, I wanted a pic of the down arrow. At first the sendkeys didn't work, and I did something, and it began working. Just cannot recall what that something was.

Anyway, I don't want the user to have to make a decision on errors when error trapping isn't working. So I think I may have to draw a user form combo-box in the cells and code them instead. I am working tomorrow and Thursday, so maybe I will have time to check if answers come before then... and go from there.