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

Hi Jimmike1,

Your code worked for me, once i changed:

TimeValue("1700:00")

to

TimeValue("17:00:00"),


---
Regards,
Norman



"jimmike1" wrote in
message ...

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

Norman Thanks for your reply. I'll try it


--
jimmike1
------------------------------------------------------------------------
jimmike1's Profile: http://www.excelforum.com/member.php...o&userid=31076
View this thread: http://www.excelforum.com/showthread...hreadid=507511