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