Test whether chosen dates is after today's date

Hi guys

I have a minor problem. I have a userform where the user can choose a date and I have to make a code which test whether this date is legal (meaning that chosen date >= today's date) before the user can continue with the next userform (i.e. the "date-test" is done when the user clicks on a "next"-button and is not allowed to continue before a legal date is chosen).

Any help is very much appreciated. Thanks for all your help in advance.

Hi, h0ps,

maybe this can get you an idea of how to get things going:

Please Login or Register  to view this content.

Input in Textbox1 like 01. Jan. 2012 or 01.01.2012.

HTH
Holger