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 vote159 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote142 views1 answer
Vba word pdf table to excel
VBA
0 vote163 views1 answer
Vba copy file
VBA
0 vote141 views1 answer
Excel text to columns line break
VBA
1 vote146 views1 answer
Excel vba hide zero values
VBA
0 vote156 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote200 views1 answer
Excel vba protect content
VBA
0 vote177 views1 answer
Create new worksheet excel visual basic
VBA
7 votes172 views1 answer
Excerl vba array to range
VBA
0 vote161 views1 answer
Sendkeys vba selenium
VBA