Adding a delay to a VBE program

[SRG]

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 <br>
<br>
Wait = Now<br>
Do Until DateDiff(&quot;s&quot;, Wait, Now) &gt; 2<br>
Results = DoEvents<br>
Loop<br>
<br>
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. <br>
<br>
Any help would really be appreciated.<br>
<br>

 

[raviman]

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.<br>
<br>
<p>Ravi Kochher<br><a href=mailto:rkochher@velos.ssind.com>rkochher@velos.ssind.com</a><br><a href= > </a><br>

 

[Alt255]

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