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 vote139 views1 answer
Excel vba extract year
VBA
11 votes268 views1 answer
Excel vba How to URL encode a string
VBA
22 votes275 views1 answer
Xl vba check for folder
VBA
0 vote161 views1 answer
Excel vba move down to next visible cell
VBA
0 vote142 views1 answer
Nested if else in vb.net
VBA
0 vote143 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote145 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote151 views1 answer
Vbnet check if string is only numbers
VBA
0 vote134 views1 answer
Loop through lines in text file vb net
VBA
0 vote144 views1 answer
Vba sort multiple columns
VBA