accessing Undo on worksheet change event

[GeneralDisarray]

Does anyone no how to undo a worksheet change automatically? I would like to capture the value that Target had before it was changed, and if the user chooses, undo the change they have made.

(generic example below)

Please Login or Register  to view this content.

[GeneralDisarray]

Also, I tried application.undo... but that causes the worksheet change to fire again! get stuck in a loop


Edit-----
TO AVOID THE LOOP. USE THIS:

Application.EnableEvents = False
Application.Undo
Application.EnableEvents = True

Turns off the event macro for the one time... duh!