Undo button from reset button

Hi,
I have a reset button in my worksheet and I added a UNDO button. Can you please create a code for me for the undo button. Thank you :o)

Please Login or Register  to view this content.

Hi,
Let me clarify. The reset button is to clear the A13-AE34 and AN13-AS34 cells. If for some reason I accidentally reset those cells, I want to be able to "undo" and bring those data back to the worksheet.

Thanks.

Hi,
Is there any simple code like my reset code.

Like this:
Sub Undo_Click()
[A13:AE34,AN13:AS34].Value = ""
End Sub

I am not too familiar with the vba code so I thought it will be easier :o)

thanks.

No. You can't undo action done by VBA. As whenever any code runs, it wipes undo cache.

Alternate approach is to store values in memory and put it back to sheet when Undo is pressed. However, that will require just as much (or more) coding as above

Great! Thank you.

Hi,
I added 2 more worksheet. I name the worksheet Page 1 and Page 2. Can you please edit the code including the 2 worksheet. Same format with the original worksheet. Thanks.

Please Login or Register  to view this content.