OnTime

[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

[Norman Jones]

Hi Jimmike1,

Your code worked for me, once i changed:

TimeValue("1700:00")

to

TimeValue("17:00:00"),


---
Regards,
Norman



"jimmike1" <jimmike1.22ku1a_1138841402.0015@excelforum-nospam.com> wrote in
message news:jimmike1.22ku1a_1138841402.0015@excelforum-nospam.com...
>
> 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
>
>
> --
> jimmike1
> ------------------------------------------------------------------------
> jimmike1's Profile:
> http://www.excelforum.com/member.php...o&userid=31076
> View this thread: http://www.excelforum.com/showthread...hreadid=507511
>

[jimmike1]

Norman Thanks for your reply. I'll try it