OnTime

  • Thread starter Thread starter jimmike1
  • Start date Start date
J

jimmike1

I'm sure this has been asked many times before.

Sub TimeTrigger()
Application.OnTime TimeValue("1700:00"), "UpdateDates"
End Sub

"UpdateDates" is a procedure that works fine on its own. But the
OnTime method fails to call it. Why? I'd appreciate any help. Thanks
 
Hi Jimmike1,

Your code worked for me, once i changed:

TimeValue("1700:00")

to

TimeValue("17:00:00"),
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cancel Ontime routine 3
Error using OnTime Method 3
Cancelling Application.OnTime - error message 2
Cancelling Application.OnTime 4
Run time error 2
OnTimer - The macro 'macro name' cannot be found. 2
OnTime method 1
Automatic increment of onTime 4

Back
Top