Subtract from last cell modified by macro?

[Roshman]

I'm building a work effort tracker for employees to record what they do throughout the day and submit it via email, and I've got everything but the "Undo" button working. Right now I have 13 buttons that add +1 to cells C9:C21, and a submit button that copies those cells into an email. What I'm trying to find a solution for is if someone clicks the wrong button, say clicks Inbound Call instead of Outbound Call, which would +1 to C9 instead of C10.

I've read that coding an undo macro button is pretty much impossible, but is there a way to locate the last cell modified by a macro and subtract 1 from it? Or possibly identify the cell contained in the last macro run and -1 from it that way? I'm not terribly experienced with macros, and most of what I've put together I've actually found on this forum, so any help is appreciated.

Thank you,
Roshman

[coreytroy]

I think you may need to write a short bit of code to input a variable value or string to a designated cell to tell what has been run. Then use this to reverse what was run.
EG.
Inbound Call: Add

Please Login or Register  to view this content.

to the start.

Add 2 other codes (Reverse_Inbound & Reverse_Outbound)to do the reverse of the selected macro.

Add an UNDO Button to :

Please Login or Register  to view this content.

Then it begs the Q.
Do you need a reverse option for the reverse code etc....