| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I tell my Macro to stop running for 10sec?
Hi, Is there anyway to tell a macro to "Pause" when it gets to a certain stage for a set amount of time? After the set amount of time I need it to start again! Any ideas? Regards Garry -- Gazzr ------------------------------------------------------------------------ Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075 View this thread: http://www.excelforum.com/showthread...hreadid=534402 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I tell my Macro to stop running for 10sec?
Try this:
Sub waiting() Application.Wait (Now + TimeValue("0:00:10")) MsgBox "Hello" End Sub Or, you may also have a look at the OnTime method. Regards, Edwin Tam http://www.vonixx.com "Gazzr" wrote: Hi, Is there anyway to tell a macro to "Pause" when it gets to a certain stage for a set amount of time? After the set amount of time I need it to start again! Any ideas? Regards Garry -- Gazzr ------------------------------------------------------------------------ Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075 View this thread: http://www.excelforum.com/showthread...hreadid=534402 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I tell my Macro to stop running for 10sec?
from the vb help file
This example runs my_Procedure 15 seconds from now. Application.OnTime Now + TimeValue("00:00:15"), "my_Procedure" -- Gary "Gazzr" wrote in message ... Hi, Is there anyway to tell a macro to "Pause" when it gets to a certain stage for a set amount of time? After the set amount of time I need it to start again! Any ideas? Regards Garry -- Gazzr ------------------------------------------------------------------------ Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075 View this thread: http://www.excelforum.com/showthread...hreadid=534402 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I tell my Macro to stop running for 10sec?
They were both excellent answers. I'll make sure I check out "Help" next time! Thanks Garry -- Gazzr ------------------------------------------------------------------------ Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075 View this thread: http://www.excelforum.com/showthread...hreadid=534402 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop Macro running when I save the workbook | Excel Worksheet Functions | |||
| How do I stop a Macro from running? | Excel Worksheet Functions | |||
| How to stop a macro while it is running ? | Excel Programming | |||
| When Save As stop running macro | Excel Programming | |||
| How to Pause or Stop a running Macro | Excel Programming | |||
![Gazzr[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
