Input Box Date validation loop

[drgkt]

Hi.
I need an input box where the user enters a date in format yyyy-mm-dd OR yyyy/mm/dd (all 4 digits of year entered and single numbered days and months must have a leading 0).
This date must be greater than sheet1 N1.
The valid entry of the input box will be stored in sheet 1 O1.
If a valid entry is not entered the input box will persist! (No cancel choice).

Thanks

[AlphaFrog]

User can enter the date in any valid date format. The code will format the entry to "yyyy-mm-dd"
The cancel button is present but doesn't allow canceling.

Please Login or Register  to view this content.

[drgkt]

Great!
I 've got 2 questions.

1. On my machine, I am using date format yyyy-mm-dd. If I run this on a machine of another locale where the date format is dd-mm-yyyy, will there be a problem?
That is, will the date in O1 be stored in yyyy-mm-dd or dd-mm-yyyy?

2. Just for testing today's date in d/m/yy, 4/2/17 is not accepted on my machine.

[AlphaFrog]

This will use the user's system date format. So it will change depending on the users locale.

The format of the date displayed in cell O1 will be whatever you set the cell formatting to. You could also set it to a generic Short Date format and it would use the user's system setting. The code works independent of the O1 cell formatting.

Please Login or Register  to view this content.

[drgkt]

Very Good, thanks!