User Reminder form

[fryes04]

Hi everyone

I've been working on a user form which some staff at work have asked for. I looking to create an event form so that staff members may type in text box, the name of the event, then enter a time in a DTPicker for the time the event is due and then set a time for how far in advance they would like the reminder to appear. I have already created the form and sub forms for each event (5 max for now). The form will be kept open for this to work

I understand the - application.ontime now + timeserial("00:00:00") & .wait. I have tried using this in many ways however I am still unable to get the event1 form to appear when the times match.

I have tried tried a few other forums an I only get a response such as....why excel, why not outlook. I don't think excel is the right way to do this.... Outlook can't be used as the company won't install it to any more computers and I am working on an Event calendar using javascript.

Apologies if any part doesn't make sense
Any help would be greatly appreciated

Thanks

 

[Trevor G]

Welcome to the forum,

Take a look at this link to see if it helps you. Time events would go into the Workbook On Open Event.

http://www.brainbell.com/tutorials/ms-office/excel/Run_A_Macro_At_A_Set_Time.htm

 

[fryes04]

Thank you for your reply.

I'm not able to see if this is going to work just yet but thank you for taking your time to reply. I will have a look and get back to you as soon as I can.

Thanks again

 

[fryes04]

Brilliant

Thanks for your help, it works perfectly

 

[Trevor G]

Pleased to read you have a working solution. Thanks for letting me know.