How to delay or wait for the execution of the program in Excel VBA
8.5 هزار بار بازدید -
7 سال پیش
-
In this Excel VBA tips
In this Excel VBA tips and tricks tutorial, I'll be teaching you how to make Excel VBA code to wait for specific time before it executes. Or How to delay the execution of program.
The VBA codes we're going to be using are:
1: Application.Wait Now()+TimeValue("00:00:02")
2: Declare Sub Sleep Lib "kernel32" (ByVal dwmilliseconds As Long)
Sleep 2000
*****************************
Courses:
Excel VBA for Absolute Beginners : https://goo.gl/d3EvMw
Mastering Excel VBA Userforms : https://goo.gl/Hqtf6L
*****************************
http://LLTtutorials.com
Facebook: LLtutorials
Twitter: LLTtutorials
Pinterest: LLTtutorials
The VBA codes we're going to be using are:
1: Application.Wait Now()+TimeValue("00:00:02")
2: Declare Sub Sleep Lib "kernel32" (ByVal dwmilliseconds As Long)
Sleep 2000
*****************************
Courses:
Excel VBA for Absolute Beginners : https://goo.gl/d3EvMw
Mastering Excel VBA Userforms : https://goo.gl/Hqtf6L
*****************************
http://LLTtutorials.com
Facebook: LLtutorials
Twitter: LLTtutorials
Pinterest: LLTtutorials
7 سال پیش
در تاریخ 1396/04/15 منتشر شده
است.
8,572
بـار بازدید شده