Adding a delay to a VBE program
Adding a delay to a VBE program
(OP)
I an reasonably new to VB and am looking to pause or delay an appliaction for a number of seconds. I have come up with this
Wait = Now
Do Until DateDiff("s", Wait, Now) > 2
Results = DoEvents
Loop
But this tends to pin my cpu to 100% and give me problems. I would rather it not effect my ability to go over the spreadsheet or the VBE program.
Any help would really be appreciated.
Wait = Now
Do Until DateDiff("s", Wait, Now) > 2
Results = DoEvents
Loop
But this tends to pin my cpu to 100% and give me problems. I would rather it not effect my ability to go over the spreadsheet or the VBE program.
Any help would really be appreciated.
RE: Adding a delay to a VBE program
Ravi Kochher
rkochher@velos.ssind.com
RE: Adding a delay to a VBE program