Add delay to your VBA code with Application.Wait. The following example delays code excecution 5 seconds before continuing:

Application.Wait Now + TimeValue("00:00:05")

Note: Yep, I’ve mentioned it before, however I didn’t use the term “delay”, so the person searching for it came up short.