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 votes165 views1 answer
Vba request json
VBA
0 vote158 views1 answer
Vba get workbook name
VBA
0 vote169 views1 answer
Vba simple quote
VBA
0 vote171 views1 answer
VBA Sort RossetaCode
VBA
0 vote152 views1 answer
Excel vba center userform
VBA
0 vote163 views1 answer
Excel vba unmerge sheet
VBA
0 vote148 views1 answer
Vba text to general
VBA
0 vote155 views1 answer
Excel vba address not absolute
VBA
0 vote158 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote158 views1 answer
Vb net show lines for all axis labels in chart
VBA