Posted to microsoft.public.excel.programming

jimmike1

external usenet poster

Posts: 1

OnTime

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find %ontime & SUMIF ontime ie: find matching sets within Range...	Chris T-M	Excel Worksheet Functions	3	October 10th 08 08:14 PM
.ontime	Grrrrrumpy	Excel Discussion (Misc queries)	2	April 8th 07 04:18 PM
OnTime bug?	Antonio	Excel Discussion (Misc queries)	0	June 9th 06 08:24 PM
about ontime	uma[_2_]	Excel Programming	0	January 21st 06 06:33 AM
OnTime Help	Mark Scholes	Excel Programming	1	January 30th 04 03:48 AM

All times are GMT +1. The time now is 11:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us