Userform Date Format Issues

**gtbear** · 10-30-2014, 08:18 AM

Hi,

I have created a user form for users to input data onto a spreadsheet. All works find but I wanted to put some error validation into it to pick up input errors. The issue I have is I can't get the CDATE function to understand an incorrect date. If the user inputs the date as 01/02/03 it will happily put 1st February 2003 - Perfect!! But if I put in 32/02/03 to generate an error the system happily puts the date as 3rd January 1932.

Please see my code here.

Please Login or Register  to view this content.

Can anyone let me know where I am going wrong! Or see a better way to achieve this.
I do not have DatePicker as an additional option in my Userform tool box and do not have admin rights on this machine to install it.

Thank you in advance.

**Norie** · 10-30-2014, 08:38 AM

You can use IsDate to check for a valid date.

For example.

Please Login or Register  to view this content.

By the way, you might want to consider checking the values in TextBoxDay, TextBoxMonth, TextBoxYear etc to see if they are valid.

Might even be an idea to use spin buttons to restrict what goes in the textboxes.