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 vote239 views1 answer
Excel vba cell on change
VBA
0 vote240 views1 answer
Vba string start with
VBA
0 vote272 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote248 views1 answer
VB Error Code BC30201
VBA
5 votes243 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote234 views1 answer
Vbscript for loop
VBA
0 vote254 views1 answer
Thread sleep vb
VBA
1 vote256 views1 answer
Sort using vba
VBA
0 vote244 views1 answer
Vba count all row
VBA
0 vote236 views1 answer
Vba boolean to string
VBA