Create a time delay in Excel macro code

If you want to delay the execution of the program by 30 seconds.. .then add the below code to your macro

Application.Wait Now + TimeValue("0:00:30")

likewise if you would like to delay the process by 90 seconds... then

Application.Wait Now + TimeValue("0:01:30") 

Have a great day :-)