Prevent past date in userform textbox

[SierraKilo78]

Hi,

Need some help please if possible. I have a userform with a date field in textbox. I also have a calculator form that was created separately and pops-up on the textbox enter event. What I want is when a user selects the date from the pop-up calculator, the exit evening of the textbox should check if the date is less than current date and display messagebox saying something. I have the following code but the problem is throws the error msgbox for any date which is less than 30! e.g current date is 23th of March, but when im selecting 27th of March it still is throwing the error. tried changing the code several ways up and down but guess im missing on something vital.

Can someone be kind enough to look at this and correct the error.

thanks a bunch in advance

Please Login or Register  to view this content.

[Norie]

You need to convert the text date from the 'calculator' form to a 'real' date.

That can be done using DateValue or CDate.

Please Login or Register  to view this content.

[SierraKilo78]

the ddate variable is declared at date

[SierraKilo78]

OMG!! THANKS A TRILLION. Norie

I knew I was missing something very vital.

ur a star!