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 vote121 views2 answers
Vba function return array
VBA
0 vote127 views1 answer
Excel vba combine ranges
VBA
0 vote124 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote135 views1 answer
Vba min
VBA
1 vote122 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote123 views1 answer
Get current url vb.net
VBA
0 vote133 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote150 views1 answer
Vba cell all borders
VBA
0 vote133 views1 answer
Vb.net change cursor to wait
VBA
3 votes134 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA