Undo Please?

[Jerett]

I have another dumb question.
How can I enable a macro/subroutine to use the undo
command?

The sub is simple:
Private Sub CommandButton3_Click()
Range("H16").Value = (Range("I16").Value + Range
("J16").Value) * Range("F16").Value
End Sub

 

[J.E. McGimpsey]

Take a look at John Walkenbach's explanation:

Undoing a VBA Subroutine
http://j-walk.com/ss/excel/tips/tip23.htm

 

[Rob van Gelder]

Application.Undo
Apparently it must be the first command in your macro