Public Sub Delay(PauseTime As Long) Dim Start As SingleStart = Timer Do While Timer < Start + PauseTime DoEvents Loop End SubPrivate Sub Command1_Click() Debug.Print Now Delay 20 Debug.Print Now End Sub
Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long)调用方法: Sleep 20000
API Sleep n*1000
Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long)推荐使用Sleep
sleep??
忘了是那个?
如果都不是,就用timer
Dim Start As SingleStart = Timer
Do While Timer < Start + PauseTime
DoEvents
Loop
End SubPrivate Sub Command1_Click()
Debug.Print Now
Delay 20
Debug.Print Now
End Sub
Sleep 20000