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 vote199 views1 answer
Excel vba protect content
VBA
0 vote196 views1 answer
Vba leading zeros in string
VBA
-1 vote207 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote190 views1 answer
Remove first character from string vb
VBA
0 vote207 views1 answer
Excel last used row
VBA
0 vote193 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote224 views2 answers
Checking and changing system volume vb.net
VBA
0 vote202 views1 answer
Excel text to columns line break
VBA
31 votes246 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote211 views1 answer
VB get external IP address
VBA