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

5 votes244 views1 answer
Excel vba low word from Long Integer
VBA
0 vote227 views1 answer
Enable macros on opening workbook vba
VBA
0 vote235 views1 answer
Vba range clear formatting
VBA
2 votes220 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote228 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote226 views1 answer
Vba get workbook name
VBA
0 vote248 views1 answer
Move bindingnavigator vb
VBA
0 vote174 views1 answer
How to self delete a vbscript file
VBA
0 vote250 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote227 views1 answer
Excel vba cell on change
VBA