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

2 votes339 views1 answer
Excel vba check if key is in collection
VBA
0 vote352 views1 answer
Excel text to columns line break
VBA
11 votes499 views1 answer
Excel vba How to URL encode a string
VBA
8 votes428 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote349 views1 answer
Vba change named range address
VBA
0 vote316 views1 answer
How to self delete a vbscript file
VBA
0 vote334 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote352 views2 answers
Vba remove line breaks
VBA
0 vote385 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote345 views1 answer
Sendkeys vba selenium
VBA