Breaking News: Grepper is joining You.com. Read the official announcement!

excel run macro every 5 minutes

Tayo answered on November 25, 2020 Popularity 3/10 Helpfulness 4/10

answer excel run macro every 5 minutes

excel run macro every 5 minutes

Comment

Public RunWhen As Double
Public Const cRunWhat = "my_Procedure"

Sub StartTimer()
RunWhen = Now + TimeSerial(0, 10, 0)
Application.OnTime earliesttime:=RunWhen, procedure:=cRunWhat, _
     schedule:=True
End Sub

Sub StopTimer()
   On Error Resume Next
   Application.OnTime earliesttime:=RunWhen, _
       procedure:=cRunWhat, schedule:=False
End Sub

Sub my_Procedure()
    MsgBox "hello world"
    Call StartTimer
End Sub

Popularity 3/10 Helpfulness 4/10 Language vb

Source: stackoverflow.com

Tags: excel minutes vba

Link to this answer
Share Copy Link