Sub <procedure name>()
'code to be run
Application.OnTime Now + TimeValue("00:00:00"), "<procedure name>"
End Sub
'example Sub runsEveryTenSeconds() If formClock.Visible = False Then Exit Sub Call updateClock Application.OnTime Now + TimeValue("00:00:10"), "runsEveryTenSeconds" End Sub
One thought on “What is the syntax to run a procedure based on a timer?”
Comments are closed.