Notifications
Clear all
VBA & Macros
3
Posts
2
Users
0
Reactions
54
Views
Topic starter
- 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
Hi Nels,
Perhaps this line of code can help
Application.Wait (Now + TimeValue("00:00:03"))
Posted : 01/04/2022 9:56 pm
Topic starter
Mr. Kang:
Thank you for your succinct response. That was exactly what I needed.
Nels
Posted : 06/04/2022 7:35 pm