Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Undo function in Userform
I'm a novice...this may be a simple one...
I have a Userform that allows adding /editing data in an Excel worksheet which works fine. I would like to provide an option in my Userform to UNDO it if they made a mistake and revert back the data back to its previous state. How and where should I code it under ? Thanks a bunch!! Tyro |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Undo function in Userform
As far as I know...and happy to be told otherwise. but When using
macros/code to make changes you lose the ablity to undo...as a normal operation. The only way is reverse your code...or keep a copy on another sheet of the step before last change and copy it across to the current sheet you are editing. Tyro wrote: I'm a novice...this may be a simple one... I have a Userform that allows adding /editing data in an Excel worksheet which works fine. I would like to provide an option in my Userform to UNDO it if they made a mistake and revert back the data back to its previous state. How and where should I code it under ? Thanks a bunch!! Tyro |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Undo function in Userform
You would have to code is explicitly. That means you would have to record
what the previous values were before you change them. Then in your undo routine, restore those values by writing them back to the appropriate cells. There is no build in support for this. It is all done by your code. -- Regards, Tom Ogilvy "Tyro" wrote: I'm a novice...this may be a simple one... I have a Userform that allows adding /editing data in an Excel worksheet which works fine. I would like to provide an option in my Userform to UNDO it if they made a mistake and revert back the data back to its previous state. How and where should I code it under ? Thanks a bunch!! Tyro |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Undo function in Userform
Thanks for the feedback...I'll give that a try...it might take me a while to
get my codings right or even make it work !! Thanks again !! stevebriz wrote: As far as I know...and happy to be told otherwise. but When using macros/code to make changes you lose the ablity to undo...as a normal operation. The only way is reverse your code...or keep a copy on another sheet of the step before last change and copy it across to the current sheet you are editing. I'm a novice...this may be a simple one... I have a Userform that allows adding /editing data in an Excel worksheet [quoted text clipped - 5 lines] Thanks a bunch!! Tyro |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Undo function in Userform
Thanks for the feedback..!!...I'll try this option as well.. I'm following
the suggested logic, it will probably just take me a while to code this properly. ..Thanks, again! Tom Ogilvy wrote: You would have to code is explicitly. That means you would have to record what the previous values were before you change them. Then in your undo routine, restore those values by writing them back to the appropriate cells. There is no build in support for this. It is all done by your code. I'm a novice...this may be a simple one... I have a Userform that allows adding /editing data in an Excel worksheet [quoted text clipped - 5 lines] Thanks a bunch!! Tyro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot enable redo-undo function | Excel Worksheet Functions | |||
Excel's Undo Function | Excel Worksheet Functions | |||
Why is my undo function in Excel only can undo the last 1 or 2 ch. | Excel Worksheet Functions | |||
Undo with custom Paste function | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |