OnTime Method Example

This example runs the macro named "MyMacro" in the current module at 3:55 P.M.

Application.OnTime When:="15:55:00", Name:="MyMacro"

This example runs the macro named "Macro1" 15 seconds from the time the example is run. The macro name includes the project and module name.

Application.OnTime When:=Now + TimeValue("00:00:15"), _
    Name:="Project1.Module1.Macro1"

This example runs the macro named "Start" at 1:30 P.M. The macro name includes the project and module name.

Application.OnTime When:=TimeValue("1:30 pm"), _
    Name:="VBAProj.MyModule.Start"