Dave, I tried your suggestion on validation, but it is too short and will not do what I need comments to do.


Simon, Can you please give me an explaination as to what this code does. I've never seen anything like this. Looks interesting, but I simply don't know how even to use it.

How do I call the code since it is Private or do I simply attach it to a macro?

I can not use a macro in each cell that I have a comment