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 vote212 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote201 views1 answer
Vba find sub dictionary
VBA
0 vote222 views1 answer
VBA
VBA
0 vote215 views1 answer
Excel vba StartUpPosition
VBA
0 vote208 views1 answer
Backspace key has stopped working visual studio
VBA
5 votes222 views1 answer
Excel vba get user selected range
VBA
1 vote214 views1 answer
Vbs run
VBA
1 vote219 views1 answer
What does vbs stand for
VBA
4 votes210 views2 answers
Vba last row
VBA
1 vote202 views1 answer
Excel vba compare 2 rows
VBA