Excel "Undo" in VBA code??

[jjst34]

Is there a way to write a small piece of code that will undo the last thing entered into any given cell??? Just like the undo command? If it matters I am using Excel 97. Thanks!

[HeddaLora]

I don't know what the VBScript code would be for it, but why not just use "control-z" ? (I suppose if you really had to have it in code, you could put "control-z" in the code.)

Hedda Lora

[jjst34]

Originally posted by HeddaLora
I don't know what the VBScript code would be for it, but why not just use "control-z" ? (I suppose if you really had to have it in code, you could put "control-z" in the code.)

Hedda Lora

I needed it in code because I have a sheet that other users will be using.. I put in a piece of code that will not allow the value of a formula in a cell to go over a certain percentage.. If it does it brings up a message that tells the user, but when they hit ok or cancel it allows the previous entry, so I needed to "force" an undo...
Anyways,, the way to do it, I found out is to put
application.undo
in the code.. pretty simple! thanks for ur suggestion though