Determine if Comment is Changed Like the Worksheet_Change event

[Jonathan78]

Hello all,

The following code lets me write changes on the INTERFACE sheet to the DBS sheet.
I also managed to copy comments to the DBS-sheet.
However the copying of comments only works if the cell value is changed, this is because of the Worksheet_Change event.
Is it possible to detect if the comment itself is changed (edited or deleted)?

Please Login or Register  to view this content.

[Neil_]

Nope, it doesn't fire an event, but you can create a macro to add a comment and add this macro to the right click menu. This will allow you to add a comment and fire custom code afterwards.

Similar to this thread

http://www.excelforum.com/showthread...t=#post4475437

[mikerickson]

Excel doesn't have CommentChange event, so a custom event will have to be written.
Note that his does not respond to changing a comment via code, it only works on comments changed by the user.

Please Login or Register  to view this content.

[Jonathan78]

Both suggestions work fine. Thank!