OldCityCat
12-13-2017, 09:26 AM
I have a UserForm designed as a TimeCard in both Outlook 2010 & 2016 which I would like to roll out in January.
For the first month I would like to open the TimeCard at 3 intervals per day 8:00, 12:00 and 4:00
As reminder for the user to Clock-In and Clock-Out.
I tried using Application.OnTime to open the TimeCard without much success.
Public Sub OpenTimeCard()
'Runs a macro at 8:00 AM
Application.OnTime TimeValue("08:00:00"), "UserForm_Initialize"
End Sub
Thank you in advance for any ans all suggestions
OldCityCat
For the first month I would like to open the TimeCard at 3 intervals per day 8:00, 12:00 and 4:00
As reminder for the user to Clock-In and Clock-Out.
I tried using Application.OnTime to open the TimeCard without much success.
Public Sub OpenTimeCard()
'Runs a macro at 8:00 AM
Application.OnTime TimeValue("08:00:00"), "UserForm_Initialize"
End Sub
Thank you in advance for any ans all suggestions
OldCityCat