Can I add a 'Undo" button a an Excel Form?

[smason48]

I have an excel form which users will input quantities of text into. (Unfortunately using excel when I should be using Access but this is not allowed!) It would be fantastic for users to be able to 'Undo' if they accidentally wipe out a box of text. I adding the code below to a command button on the form however no luck. I have tried to find an answer on the web but it seems nobody else has tried this (that may be a hint).

Any ideas? Much Appreciated!


<code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">Sub UndoLastAction() With Application .EnableEvents = False .Undo .EnableEvents = True End WithEnd Sub</code></pre>