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 vote353 views1 answer
Vba integer to double
VBA
0 vote342 views1 answer
Excel vba ternary
VBA
0 vote350 views1 answer
Loop through lines in text file vb net
VBA
5 votes370 views1 answer
Excel vba get user selected range
VBA
0 vote361 views1 answer
Vba remove the first character of string
VBA
0 vote320 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote320 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote356 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
2 votes329 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote325 views1 answer
Vba verticalalignment
VBA