Undoing a "click" on a cell inside VBA

Hi,

I just implemented a nice Event Handler with forum's help (TMS, thank you!) where I sense cell clicks and update a counter. However, being a stickler for UI experience I always need to "Undo" any previous action to help with any unintended clicks. Well, it looks like this undoing may not be possible (or easy) as with the regular Excel Undo button on the top left corner! My immediate searches tell me that I have to write another macro to undo any event handling macro did. Do you guys know of any simple Undo trick while you are inside of a VBA macro? I.E., just forget the previously recognized "click" in some cell?

Thanks much in advance.

Best, Nash

Originally Posted by PeteABC123

Best practice is to envision possibly going back after the macro runs. If you think you might need to go back, SAVE your file first. Run the macro, and exit w/o saving if it didn't go well..
Running a Macro deletes your UNDO list.

(Edit: did stumble into this though. . .I can't vouch for it.) https://jkp-ads.com/Articles/UndoWithVBA00.asp


Pete

I've implemented a sort of "Undo" button but I can't seem to undo everything that happened on the click! In the attached code I can highlight the cell clicked and then un-highlight it with a double click.

However, when I click and highlight I also transfer the contents of the clicked cell into an accumulator. So if I double-click the same cell I should un-highlight AND also reduce the accumulator value by the same amount that was added upon clicking the first time .. right? This is where I see the problem -

It works well the first few times - i.e., click => highlight and add to accumulator; double-click => un-highlight and subtract from accumulator. After a few clicks, the accumulator contents stays the same and won't change!

Is the problem too many clicks and double-clicks? Why does the part of accumulator changes fail after a while?

Can somebody test my code and let me know where the bug is?
Thanks much in advance.

Best, Nash