Excel run macro every 5 minutes

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

Source: stackoverflow.com

Similar codes

0 vote275 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote284 views1 answer
Change form background image vb
VBA
0 vote280 views1 answer
Vba option button selected
VBA
0 vote325 views1 answer
Vba userform textbox wrap text
VBA
0 vote299 views1 answer
Vba parameter adodb null value
VBA
3 votes316 views1 answer
Extract word in a text in excel
VBA
9 votes391 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote304 views1 answer
Remove last 8 characters from string vb
VBA
0 vote263 views1 answer
Vba first line of string
VBA
0 vote306 views1 answer
Excel vba add reference programmatically
VBA