| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I control the macro's running time?
Hello Ming, The Sleep API will halt all execution from millseconds to hours. Add new VBA module to your project anad paste the following code into it. EXAMPLE OF STOPPING FOR 1 MINUTE Sleep(60000) Code ------------------- 'Time is in Milliseconds. 1 millisecond = 1/1000 of a second Public Declare Function Sleep _ Lib "kernel32.dll" _ (ByVal dwMillisecs As Long) As Long ------------------- Sincerely, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=49560 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| running macro's in Excel 2007 | Excel Worksheet Functions | |||
| Running XY chart labeller using a macro's parameters and arguments. | Charts and Charting in Excel | |||
| Why do i have to re-assign macro's all the time | Excel Programming | |||
| Assigning Macro's to control buttons. | Excel Programming | |||
| shortcut key not not running macro's all of a sudden | Excel Programming | |||
![Leith Ross[_408_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
