VBA Sleep Snippet

The solution for “VBA Sleep Snippet” can be found here. The following code will assist you in solving the problem.

#If VBA7 Then Public Declare PtrSafe Sub Sleep Lib “kernel32” (ByVal dwMilliseconds As LongPtr) ‘For 64 Bit Systems#Else Public Declare Sub Sleep Lib “kernel32” (ByVal dwMilliseconds as Long) ‘For 32 Bit Systems#End IfSub SleepTest()MsgBox “Execution is started”Sleep 10000 ‘delay in millisecondsMsgBox “Execution Resumed”End Sub

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts