Pausing a macro... 1

[Rjc8513]

I have a macro which uses a counter and displays the counter result as part of a message in the StatusBar (Processing 15 of 300 records...).

When the total number of records is small, the procedure runs so quickly that the message cannot be read.

Is there a way to add a delay or a pause to the code to slow down the procedure so the message can be read?

Thanks.

Richard...

 

[JohnYingling]

Dim dteStart as date

dteStart = Now   ' not the start time(date-time)
.....Processing
Do While((Now - dteStart) / 86400 < 5) ' 86400 secs per day
Loop

http://WWW.VBCompare.Com

 

[JVFriederick]

I always suspected over the years that certain programmers did this . . . . . . . . . LOL