tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,834
- Office Version
- 365
- 2019
- Platform
- Windows
I would like to do the following:
1. Enter some data on a worksheet manually
2. Click on a button to run some code
3. Be able to undo action 1.
I came across this article:
but I can't implement it.
I copied the two class modules and created my own simple subroutine:
then I entered a value on the worksheet and ran Macro1.
What I expected to happen is if I now clicked undo, that the value I entered on the worksheet to disappear.
Am I mistaken the code on the website is not for this purpose?
Thanks
1. Enter some data on a worksheet manually
2. Click on a button to run some code
3. Be able to undo action 1.
I came across this article:
but I can't implement it.
I copied the two class modules and created my own simple subroutine:
Code:
Sub Macro1()
Msgbox "Hi"
End Sub
then I entered a value on the worksheet and ran Macro1.
What I expected to happen is if I now clicked undo, that the value I entered on the worksheet to disappear.
Am I mistaken the code on the website is not for this purpose?
Thanks