Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Undo Please?


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 493
Default Undo Please?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,236
Default Undo Please?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't undo Mesak Excel Discussion (Misc queries) 3 August 24th 07 01:17 PM
undo F11 key Kerry Charts and Charting in Excel 1 April 7th 06 11:46 PM
Undo yarp Excel Discussion (Misc queries) 5 August 15th 05 05:59 PM
UNDO - how many times can I UNDO? Jane Excel Worksheet Functions 2 May 19th 05 03:03 AM
Why is my undo function in Excel only can undo the last 1 or 2 ch. 1111111111111111111111111111111111111111 Excel Worksheet Functions 1 November 24th 04 11:13 AM


All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"