Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OnUndo
Hello,
I have a piece of code that runs in the worksheet_Change event. I change the target.value in the code. My question is that I want to create an undo for this. I need the value of target prior to the code being run. Any ideas? Thanks, Ernst. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OnUndo
Hi Ernst,
See JohnWalkenbach's Undo page: http://www.j-walk.com/ss/excel/tips/tip23.htm --- Regards, Norman wrote in message ... Hello, I have a piece of code that runs in the worksheet_Change event. I change the target.value in the code. My question is that I want to create an undo for this. I need the value of target prior to the code being run. Any ideas? Thanks, Ernst. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.OnUndo Questions - Loses Prior Undo's and Runs 1x | Excel Programming |