I want to pop up a MsgBox if if user enters date like 2015.04.30 instead of 30.04.2015.

Dear experts,
Following code redirects user to enter date as intended format.
I want to pop up a MsgBox if user enters date like 2015.04.30 instead of 30.04.2015.
Any idea?

Please Login or Register  to view this content.

Thanks in advance.

Useful link:
https://msdn.microsoft.com/en-us/lib.../ff839468.aspx

Try:

Please Login or Register  to view this content.

Hi BellyGas,
Thanks for answer. But your code doesnt work.

Hi Kaper,
I simplyfied your code below. Is there any mistake in following code?

Please Login or Register  to view this content.

In other words, I have deleted following lines in your code.

Please Login or Register  to view this content.

The part you deleted was an attempt to make a valiw windows date out of sybmitted string.
99.99.9999 seems to fit your "short version", but for sure it is not a valid date :-)

Hi Kaper,
Run following code without changing pop up date then see there is an error on your code..
Note: Be careful x and y declerations...

Please Login or Register  to view this content.

As for declarations

Please Login or Register  to view this content.

is equivalent to

Please Login or Register  to view this content.

x is text or boolean (cancel clicked)
y is a date if everytingg goes fine. if not OK, then y is not OK, set but err.number is <>0

as for the code - there is an error in your code:-P you changed checking x with y in the long ElseIF
compare posts #6 (your code) and #3 (my code)

To drill it down a bit: what is your date format in system?
try

Please Login or Register  to view this content.

to see it.

if it is dd.mm.yyyy then even your code shall be fine. If not (in my case it is yyyy-mm-dd) of course not.
That's why I checked x there - x is a string, as user writes in the inputbox.

PS. note also my comment in post #5 why this checking is needed at all