VBA to force year to YYYY

[jshaw82]

Hi. I'm using the following code (this is a the beginning) for a user input where the user has to enter a date. Now whilst the VBA says to enter DD/MM/YYYY, i want to make it so if a user decides to input YY/DD/MM it automatically formats YYYY.

Please Login or Register  to view this content.

does format the cell to DD/MM/YYYY if the user has entered DD/MM/YY it doesn't change it to YYYY.

Here's the code:

Please Login or Register  to view this content.

Thanks in advance

[jshaw82]

Ok, i've sorted it:

Please Login or Register  to view this content.

[Jakobshavn]

Here is an easy way inputting the date as a string:

Please Login or Register  to view this content.

so if the user inputs Christmas 2013 as

25/12/2013

Christmas gets entered with the correct format, but if the user inputs Christmas 2013 as

13/12/25

Christmas still gets entered with the format "YYYY"