application.ontime date and time problem

[ckjason]

Please Login or Register  to view this content.

How could i add specific date and time to the application.ontime function.

if i write
Application.OnTime "2/2/2013" & " " & "12:00:00 PM", "Sheet1.test2"

it will function immediately..why? i wanted run on specific date and time only..

[OllieB]

You may want to change the OnTime statement to:

Please Login or Register  to view this content.