If you go to the worksheet PTO Log, and click on the submit entry the user form will appear, randomly select a name, put in the amount of hours, when you go to click a "start date", a pop up calendar will appear, once you select a date, both the calendar and the userform, will close, not recording any of the data.
Here is the line of code that is giving me an issue:
Unload Me
Sheets("PTO LOG").Activate
in both the frmPTOLog and frmPTODelete, the userform prematurely closes, without recording the data. If you take that code out of both forms, the userform works correctly.
What I was trying to do, was to have the file go back to the Log worksheet after the information was recorded in the calendar.Any ideas?
Also there is another issue, but I will address that in another thread...also for reference I am using 2010 excel, but this will be used in both 2007 and 2003.
Bookmarks