Posted to microsoft.public.excel.programming

ExcelMonkey[_127_] ExcelMonkey[_127_] is offline

external usenet poster

Posts: 1

On time Event

I am trying to program an alarm like this:

Sub SetAlarm()
Application.OnTime TimeValue("12:12:00 pm"), "DisplayAlarm"
End Sub

Sub DisplayAlarm()
Beep
MsgBox "Wake up. Its time for your afternoon break!"

End Sub

However it never seems to go off. I have put in a regular module.
What have I done wrong?

Thank-yo

--
Message posted from http://www.ExcelForum.com

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
Time remaining until event	Highbury 1[_2_]	Excel Discussion (Misc queries)	2	March 9th 09 02:57 PM
Calculate Ending time using Start Time and Elapsed Time	Chief 711	Excel Worksheet Functions	5	May 13th 08 04:34 PM
Event Procedures: Event on Worksheet to fire Event on another Worksheet	Kathryn	Excel Programming	2	April 7th 04 07:35 PM
change event/after update event??	scrabtree23[_2_]	Excel Programming	1	October 20th 03 07:09 PM
OnTime event not firing in Workbook_Open event procedure	GingerTommy	Excel Programming	0	September 24th 03 03:18 PM

All times are GMT +1. The time now is 11:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us