[RESOLVED] run sub every x minutes

[inosent]

lets say i have a routine

private sub dostuff()
'do things
end sub

but i want it to run every 15 minutes

is there some code i can add that can do that?

[isnoend07]

try this
Private Sub Form_Load()
Timer1.Interval = 60000
Timer1.Enabled = True
End Sub

Private Sub Timer1_Timer()
Static t As Long
If (t = 0) Then
Do things here
Debug.Print Now
End If
t = (t + 1) Mod 15 '15 minutes
End Sub

[inosent]

thanks, looks good

[VBFnewcomer]

inosent please see this thread http://www.vbforums.com/showthread.p...ighlight=timer