Hello there,
I'm trying to use this same VBA code as this post http://www.excelforum.com/excel-prog...ml#post3597872, but can't get it to work? I have inputted this in my normal module under:
-VBAProject (LL Text.xlsm)
-Modules
-Module 2
However whenever I go back to my sheet and add the =HasComment(A1) into my conditional formatting nothing happens. If I press Alt+F8, the Module isn't selectable to run. Is there a way to have this run automatically when I insert a comment to my document?
This is the first time I'm trying to use a VBA code so I'm sure it's something I'm doing wrong.
Thanks,
Lorne
Bookmarks