Using Excel Undo Functionality using VBA

[NatHunter]

Is it possible to use the excel undo functionality from VBA code?

If so, how is it done?

 

[xlbo]

There is no UNDO function within VBA - AFAIK, you could only reference it by using SENDKEYS to activate the menu option

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[NatHunter]

Thanks, Geoff.

I cannot seem to get excel ('97) to recognise a CTRL (^) key in sendkeys - any ideas? I can get the shift and alt keys to work but not CTRL:

Private Sub cmdUndo_Click()
Call SendKeys("^Z", True)
End Sub

Doesn't do anything. This is attached to a command button...

Paul

 

[xlbo]

use
Application.sendkeys

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[PHV]

In Excel97 SendKeys "^Z" works as expected, ie sends Ctrl-Z to the active window. However, a macro action is NOT undoable.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244