Adding a delay to a VBE program

SRG · Oct 21, 1999

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.

raviman · Oct 22, 1999

You can use either a timer control for this or if you have memoy load problems then you can use the sleep API. Just open the API viewer and copy the declaration for the sleep API in you general declaration region. 
 
Ravi Kochher <a href=mailto:rkochher@velos.ssind.com>rkochher@velos.ssind.com</a> <a href= > </a>

Alt255 · Oct 22, 1999

This thread has been posted recently. The discussion was adequate. Click "next ten" until you find it.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Adding a delay to a VBE program

SRG

MIS

raviman

Programmer

Alt255

Programmer

Similar threads

Part and Inventory Search

Sponsor