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

3 votes185 views1 answer
Extract word in a text in excel
VBA
0 vote177 views1 answer
For each item in folder outlook vba
VBA
0 vote171 views1 answer
Excel vba first working day month
VBA
0 vote154 views1 answer
Excel vba open browser
VBA
0 vote180 views1 answer
Excel vba send HTTP POST to server
VBA
2 votes174 views1 answer
Excel vba check if string entirely alpha
VBA
1 vote176 views1 answer
Vbs run
VBA
0 vote176 views1 answer
Vb get ip address
VBA
0 vote166 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote208 views1 answer
How to enter Vbox manage commands
VBA