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 vote158 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote182 views1 answer
Vba round to 2 decimals
VBA
0 vote161 views1 answer
Excel vba scroll to cell
VBA
0 vote162 views1 answer
Excel vba disable alerts
VBA
0 vote184 views1 answer
Excel web scraping
VBA
0 vote160 views1 answer
Add items to combobox vb.net
VBA
0 vote161 views1 answer
VB get external IP address
VBA
2 votes150 views1 answer
Vba array contains
VBA
0 vote162 views1 answer
Excel vba chrw max value
VBA
0 vote166 views1 answer
Vba declare 64-bit ptrsafe
VBA