Is There a Comment Change Event

[JStellato]

I want to write some code if a cells comment changes. Worksheet change doesn't fire if you right click a cell and edit the comment and save it. Is there an event that does fire when the comment changes?

 

[sriram170]

hi

you can use "Private Sub Worksheet_SelectionChange(ByVal Target As Range)" if a cell property or value is changed or Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) for right click

 

[JStellato]

hi

you can use "Private Sub Worksheet_SelectionChange(ByVal Target As Range)" if a cell property or value is changed or Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) for right click

This event isn't really tied to the comment change, selectionchange could be confusing to deal with. What I'm trying to do, is insert a date stamp into a comment whenever the comment changes. SelectionChange may fail me if they edit a comment and then to get out of it, click on a different cell. (Unless I can get the originating cell that was selected.

BeforeRightClick only would partially work again, because the keyboard shortcut to edit the comment could be used.

Are there any other events I can utilize?