VBA Pause

[Fable]

Greetings,

What the VBA code in order to breal/stop a marco while executing. Thin
is a got a timer that does a count down but I need to create a puas
function into it. Any ideas!

Thanks. .

 

[Earl Kiosterud]

Fable,

You normally end your sub, the have something kick off another (or the same
one).

 

[BrianB]

2 versions. The first gets you below 1 second.


Code
-------------------

Private Declare Function Sleep Lib "kernel32" _
(ByVal dwMilliseconds As Long) As Long
'----------------------------------------------
Sub SLEEP_1second()
Sleep 1000
End Sub
'----------------------------------------------
Sub WAIT_1second()
Application.Wait Now + TimeValue("00:00:01")
End Sub
'-----------------------------------------------

-------------------