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

1 vote329 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote331 views1 answer
Vb ternary
VBA
0 vote291 views1 answer
Create new worksheet excel visual basic
VBA
22 votes463 views1 answer
Excelvba check for directory
VBA
0 vote331 views1 answer
Excel vba clear filter
VBA
2 votes301 views1 answer
Vba uppercase first letter of each word
VBA
3 votes334 views1 answer
Excel insert blank row for value change in column
VBA
0 vote317 views1 answer
Excel vba join variant array
VBA
1 vote343 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote340 views2 answers
VB
VBA