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

Function HasComment(rng As Range) As Boolean

    HasComment = Not rng.Comment Is Nothing
    
End Function
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