Is this possible ?

[AlexanderBB]

I want to run some code after a worksheet comment has been changed.

It may be impossible - if so please let me know and I'll stop looking ! In the meantime
I'm reading up on APIs (which I know nothing about) to see if that's the right place to start.

Ideally this would happen after you Insert or Edit a comment and then when the comment is exited my code would run.

Where/how would one go about achieving this ?

Thanks, ABB

 

[shg]

There is no event triggered when a comment (or any other shape) is changed, so I think you're in for a rough time.

 

[AlexanderBB]

Excel knows that comment is open and editable... and when it closes... a custom event handler
is what's needed. It's well beyond me but is it beyond doing ? Some folk here have done some pretty "impossible' things before !

 

[shg]

Maybe; we'll see.