VBA Sleep Snippet

#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

Source: exceltrick.com

Similar codes

0 vote214 views1 answer
Quit excel with save changes dialog vb.net
VBA
4 votes221 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote240 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote239 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote225 views1 answer
Remove frist letter from string vbnet
VBA
0 vote247 views1 answer
Weekday vba
VBA
0 vote238 views1 answer
Excel vba remove formatting from cell
VBA
0 vote183 views1 answer
Vba set vs dim
VBA
0 vote266 views2 answers
Excel vba number format file size
VBA
3 votes244 views1 answer
Vba not equal
VBA