Private Declare Function SetTimer Lib "user32" (ByVal hwnd As Long, ByVal nIDEvent As Long, ByVal uElapse As Long, ByVal lpTimerProc As Long) As Long Private Declare Function KillTimer Lib "user32" (ByVal hwnd As Long, ByVal nIDEvent As Long) As Long
Dim i As Long Dim Interval As Long Dim lngTimerID As Long Sub test2() Interval = 1000 lngTimerID = SetTimer(0, 0, Interval, AddressOf mysub) End Sub
Sub mysub() If i = 5 Then KillTimer 0, lngTimerID Debug.Print i i = i + 1 End Sub