VBA Sleep Excel

VBA Sleep Excel is accomplished by using the Sleep API call. API stands for Application Programming Interface. They are functions found in Windows DLL files. You have to Declare which APIs you will be using. You can declare them only in a Module. For more information about using APIs,  click here.

Here is a simple example for using the Sleep API...

VBA Sleep Excel
Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Sub SleepVBA()
Do Until i = 5
i = i + 1
Range("A1") = i
Sleep 1000
End Sub


Return from VBA Sleep Excel to VBA Code Samples

Return to our Homepage

footer for Save Time page