Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Take a look at John Walkenbach's explanation:
Undoing a VBA Subroutine http://j-walk.com/ss/excel/tips/tip23.htm In article , "Jerett" wrote: 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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Application.Undo
Apparently it must be the first command in your macro "Jerett" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't undo | Excel Discussion (Misc queries) | |||
undo F11 key | Charts and Charting in Excel | |||
Undo | Excel Discussion (Misc queries) | |||
UNDO - how many times can I UNDO? | Excel Worksheet Functions | |||
Why is my undo function in Excel only can undo the last 1 or 2 ch. | Excel Worksheet Functions |