Here is a very simple method I've used quite a bit. add a timer to your Form and set it's duration to 60000, then add this Sub.
Public Sub Pause(duration As Long) Dim Current As Long Current = Timer Do Until Timer - Current >= duration DoEvents Loop End Sub
Now, whenever you want something to Pause for a certain amount of time just write. Pause whatever ** Example **
Private Sub Command1_Click() MsgBox "This will Pause for 3 seconds.", vbExclamation, "3 Second Pause." Pause 3 MsgBox "This will Pause for 2 seconds.", vbExclamation, "2 Second Pause." Pause 2 MsgBox "This will Pause for 1 seconds.", vbExclamation, "1 Second Pause." Pause 1 MsgBox "Pause Demo Complete.", vbExclamation, "Pause Demo Complete." End Sub
It's really easy. Good Luck
|