Userform to check Date/Time format correct before copying to worksheet

I've been trying to get my userform to check that the date and time formats are correct before the information is copied to the worksheet. With coworkers not paying attention to how they enter dates and times on the userform, I've been having to go over everything to make sure it is correct. Errors like 13-Feb-1371 and 10:0092 have been popping up every once and again. So far, I've come up with the following coding, except the messagebox always pops up even if it is correct.

Please Login or Register  to view this content.

I've tried the following coding instead, but it isn't working for me.

Please Login or Register  to view this content.

Hello LoneWolf3574,

There may be several ways to solve this. To determine which would suit your specific case the best, could you please upload a sample WorkBook, for us to see how best we can help you?

Rather than fight the user, this event will convert from the users date format into yours.

Please Login or Register  to view this content.

It's not really a matter of format, it's a matter of inattentiveness by the user. The date and time are automatically advance by 2 hour increments and can be changed if needed by the user, sometimes the user tries entering data into either the date or time dropdown lists with out actually looking at the screen and ends up with something like 15-Feb-1359 for a date and 71 for a time. The useform just accepts it as all it is currently looking for is something in the date and time dropdowns. We wish to leave it that way as occasionally there is an issue where data is not collected for a significant portion of a shift due to an emergency or operation requiring the operators attention elsewhere.

I've tried this with the same level of success as before as well. I know I've got to be missing something simple here.

Please Login or Register  to view this content.