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 vote210 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote215 views4 answers
Vgrive,deb
VBA
1 vote1.9K views1 answer
Vba Remove Case Sensitivity
VBA
0 vote238 views1 answer
Excel vba unlock sheet without password
VBA
0 vote194 views1 answer
Vba add shape oval
VBA
0 vote210 views1 answer
Set column width of datagridview vb.net
VBA
4 votes207 views1 answer
Vba create directory
VBA
1 vote196 views1 answer
Vba delete array element
VBA
0 vote202 views1 answer
Vba loop through table
VBA
0 vote198 views1 answer
Vbnet check if string is only symbols
VBA