'用Sleep : Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)for i=1 to 100 ...... sleep 5000 next i
Public Function TImedPause(Secs As Long) Dim secStart As Variant Dim secNow As Variant Dim secDIff As Variant Dim Temp% ''On Error Resume Next ExItPause = False ' secStart = Format(Now(), "mm/dd/yyyy hh:nn:ss AM/PM") ' Do While secDIff < Secs If ExItPause = True Then Exit Do secNow = Format(Now(), "mm/dd/yyyy hh:nn:ss AM/PM") ' secDIff = DateDiff("s", secStart, secNow) ' Temp% = DoEvents Loop End Function
或者用一个循环,我认为还是timer比较好
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)for i=1 to 100
......
sleep 5000
next i
Dim secStart As Variant
Dim secNow As Variant
Dim secDIff As Variant
Dim Temp% ''On Error Resume Next ExItPause = False '
secStart = Format(Now(), "mm/dd/yyyy hh:nn:ss AM/PM") '
Do While secDIff < Secs
If ExItPause = True Then Exit Do
secNow = Format(Now(), "mm/dd/yyyy hh:nn:ss AM/PM") '
secDIff = DateDiff("s", secStart, secNow) '
Temp% = DoEvents
Loop
End Function