Opening a MSGBox if a word is click in the Comment vba

[Godwin117]

I'm not sure this is possible, but I am looking for a VBA to open a Message Box if the word "HERE" is clicked in a comment, this could linked if necessary. The comment is located in cell R4. I'm not sure where to start with this VBA, but I'm sure someone has dealt with this before.

 

[Yongle]

this may be useful

Hyperlinks in Comments

Need to add a hyperlink to a comment or note? It's easy to do by following the steps outlined in this tip.

excelribbon.tips.net