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 vote242 views1 answer
VBA Loop to range
VBA
5 votes249 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote240 views1 answer
Vba sheet visible
VBA
8 votes323 views1 answer
Excel vba make word from bytes
VBA
0 vote253 views1 answer
Nested if else in vb.net
VBA
0 vote261 views1 answer
Vba count all row
VBA
8 votes255 views1 answer
Excel vba make integer
VBA
1 vote226 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
1 vote274 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote246 views1 answer
Vba dictionary clear
VBA