Hi Guys,

Can you help me out.

I want to come up with a validation on Cell A1. The total number of characters that will be entered should be exactly 11. If the number of the characters that I entered is not exactly 11 it will be great if there is a macro program that will show a message box that will prompt me how many characters am I off.

any help is greatly appreciated.