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

4 votes291 views1 answer
Excel vba how to reset usedrange
VBA
8 votes377 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote332 views2 answers
Checking and changing system volume vb.net
VBA
-1 vote312 views2 answers
Excel vba delete empty rows
VBA
0 vote311 views1 answer
Vb get ip address
VBA
0 vote289 views1 answer
Putting marquee in vb.net
VBA
0 vote309 views1 answer
Vba collection key list
VBA
0 vote407 views1 answer
Vba vbcrlf chr
VBA
0 vote327 views1 answer
Excel vba paste all to each sheet in workbook
VBA
1 vote328 views1 answer
Random number generator vb.net
VBA