hourly reminder

[m1ner]

Hi,I'm not sure that I'm in right section.What I'm looking for is hourly reminder.At work I have few cut off hours where something has to be done befor that time.I was thinking to set up a pop up message 15min before due time.Everyday mon-fri this same hours.I tried to do it on my own but as confident I am that I can do it,my knowledge stopped me at the start of that task.Could someone point me in the direction where to get information that will help me to solve this?Thank you.

[ragulduy]

something like:

Please Login or Register  to view this content.

perhaps?

[ragulduy]

Although can you not just use a calender to give you reminders (a recurring appointment in outlook perhaps?)

[m1ner]

thank you for fast replay.Can't be outlook because restrictions.Pardon my stupid question but where can I enter that code?Visiual basic editor??Every day task in excel-no problem,extrodenary-me know nothing

[ragulduy]

Press alt+F11 to enter vba editor, insert a new module (insert->module) and enter the code.

Place the cursor on this line:
application.ontime "macro_1", "15:45:00"
and press F5.

This will set the code to pop-up the message box at 15:45:00.

I would suggest doing some research into the ontime method and macros so you understand how they work before using it for your work.

[m1ner]

thank you very much.I will read about that.I did not manage it this time but I know now where to look for more answers.Thanks again.