You can't do an undo for actions carried out by code. The best you could do
is write a macro that can do the opposite of the other macro.
--
RMC,CPA


"lrisser" wrote in message
...
I've written a function that validates whether data entry
into a cell matches a list of approved entries, and brings
up a message box to tell the user of an invalid entry. I
would also like the code to undo the last entry. I've
tried using sendkeys "^Z" but that doesn't seem to do it.
Any suggestions.

thanks in advance.