VBA to Add Comments based on Cell Text

Hello!

I have a VBA that can add a comment based on the cell value, however, I need it to do it for the whole worksheet and not just one cell. I am pretty new to using VBA's, so this is the best code I could find that would perform what I need. If there is a way to have it do run a vlookup, instead of me listing all the cases, that would be great as well.

Please Login or Register  to view this content.

Hope someone can help!

Someone was able to find a code for me!!

Please Login or Register  to view this content.

I just need for it to sun automatically instead of me updating it, is this possible??

Thank you Bernie! However, I was able to get a code that has the vlookup function, which is a bit easier to use, instead of me listing it case by case.

Do you know how I can actually run the code automatically everytime the cell value may change, instead of me trying to run it manually?

Please Login or Register  to view this content.

I was able to find a code for it to run automatically! Thank you for your help!!!

Please Login or Register  to view this content.