How to delay or wait for the execution of the program in Excel VBA

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