Forum

Getting VBA code to...
 
Notifications
Clear all

Getting VBA code to suspend for a period of time

3 Posts
2 Users
0 Reactions
54 Views
(@nels)
Posts: 8
Active Member
Topic starter
 
  1. How do I get VBA code to suspend for a period of time. Currently I’m using DoEvent but that results in a very high frequency of system interrupts.  I’d like to do a system interrupt with a time delay before control is returned to my VBA code.
 
Posted : 01/04/2022 6:08 pm
(@jesaheming)
Posts: 7
Active Member
 

Hi Nels,

 

Perhaps this line of code can help

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

 
Posted : 01/04/2022 9:56 pm
(@nels)
Posts: 8
Active Member
Topic starter
 

Mr. Kang:

Thank you for your succinct response.  That was exactly what I needed.

Nels

 
Posted : 06/04/2022 7:35 pm
Share: