RE: Displaying a userform reminder to appear on future days and times from current userform values of date and time...

[chazrab]

RE: Displaying a userform reminder to appear on future days and times from current userform values of date and time...

I don't know if this has been fully developed before but I need just a little guidance in the heart of the reminder I'm developing. I’ve already developed code for a userform with Textbox1, DTPicker1 (Date format) and DTPicker2(Time format) to display at multiple times on the SAME day using

t1hr = Now() + TimeSerial(1, 0, 0)
 Application.OnTime t1hr, "RunSetMSG1HR"

This will also work with any variable t for time:

t1hr = Now() + t

The RunSetMSG1HR just displays the userform. In the case above, the userform pops up 1 hour after it is entered. It works great for any other times – as long as they are all on the SAME day. One caveat is that each instance of the userform displayed at the time specified MUST BE CLOSED or the subsequent(later) userforms won't display with their future set time values.

The even bigger issue and the heart of this and any reminder created for and used within an Excel app is this:

to set reminders on future days and at multiple times during these future days. 
To me, the code must be (1) in the Workbook Open event and 
(2)  must have the ability to check against Now() for different times in cells on rows in that Date column on that and other days.

I don’t know if a For Loop or a Find and FindNext in conjunction with Application.onTime needs to be implemented.

I tried to keep this short without sacrificing detail. I feel certain this can be done, and easily with a minimum of coding. Can someone help me with this ?

Thanks for anyone's help.
cr