Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pause a macro by resetting current time
Thanks v much,
I should have mentioned I am no programmer and do most of this by recording and editing macros etc at the moment. I copied and pasted your code into mine but it did not work - do I need to change something else? Thanks again, SW "Jacob Skaria" wrote: Use this procedure to wait and call in your code Wait (0.5) Sub Wait(sngDelayInSecs As Single) EndDelay = Timer + sngDelayInSecs Do While Timer < EndDelay DoEvents Loop End Sub -- If this post helps click Yes --------------- Jacob Skaria "SW" wrote: Hi, I am creating a macro which changes the y-values in a distribution plot each second (corresponding to the values the next day). This allows one to see a distribution change over time. The problem I have is I found the following code to pause in between (so one can see the distribution shifting over time) the dates but it pauses it for 1 second and I need it to pause it for about half a second only. Here is the code (for pausing) that I currently have: newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 1 waitTime = TimeSerial(newHour, newMinute, newSecond) Application.Wait waitTime Any help greatly appreciated, thanks a million! SW |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pause a macro by resetting current time
You can use
Wait (0.5) for delay... Sub Wait() should be copied separately...may be after End Sub of your existing macro -- If this post helps click Yes --------------- Jacob Skaria "SW" wrote: Thanks v much, I should have mentioned I am no programmer and do most of this by recording and editing macros etc at the moment. I copied and pasted your code into mine but it did not work - do I need to change something else? Thanks again, SW "Jacob Skaria" wrote: Use this procedure to wait and call in your code Wait (0.5) Sub Wait(sngDelayInSecs As Single) EndDelay = Timer + sngDelayInSecs Do While Timer < EndDelay DoEvents Loop End Sub -- If this post helps click Yes --------------- Jacob Skaria "SW" wrote: Hi, I am creating a macro which changes the y-values in a distribution plot each second (corresponding to the values the next day). This allows one to see a distribution change over time. The problem I have is I found the following code to pause in between (so one can see the distribution shifting over time) the dates but it pauses it for 1 second and I need it to pause it for about half a second only. Here is the code (for pausing) that I currently have: newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 1 waitTime = TimeSerial(newHour, newMinute, newSecond) Application.Wait waitTime Any help greatly appreciated, thanks a million! SW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pause a macro by resetting current time | Excel Programming | |||
Stop / Pause a Macro using Pause button | Excel Programming | |||
Pause a macro for some time | Excel Programming | |||
programming a macro to display the current time | Excel Programming | |||
macro for current time | Excel Discussion (Misc queries) |