popup calendar when clicking on cell in userform

Hi,

I found this popup calendar on here a while ago (maybe a month?) that worked great for an application i needed it for. I am now having trouble with it and was hoping someone could shed some light on my problems

What i have is a userform with 5 textboxes to enter dates in. The calendar pops up for each one however if someone accidentally clicks inside the textbox and wants to his the cancel button or exit it, it clears the date that is currently inside that textbox. This is obviously an issue. I noticed that the value the calendar is pulling is just stored using a tag i am assuming. So if i pick June 14th on the first textbox and then click on the next textbox and just hit cancel on that calendar it will still insert June 14th into the second textbox instead of leaving it alone. Here is all the code relevant to the calendar:

Class Module:

Please Login or Register  to view this content.

Global variables:

Please Login or Register  to view this content.

Calendar Form code:

Please Login or Register  to view this content.

Code inside each textbox to open calendar:

Please Login or Register  to view this content.

Basically all i want is when i Hit the cancel button on the calendar form, i want it to do NOTHING. Any help is appreciated!

Attached an example workbook. Not sure how this works in Excel 2007.

You should be able to see what i am talking about here. If you press the button to open up the form and go to the inspections tab, if someone accidentally clicks on the date and they click the x or cancel it removes the date. Similarily, if you accidentally click it and SELECT a date, it keeps that date stored and if you were to click another cell with the calendar in it would replace the current date in there with the date that was stored.

That's unfortunate to hear about your bad luck
At least you are pro @ vb :D This is awesome. Thanks Leith!