Pop up calendar to insert date in text box on user form

Hi,

I have been looking around for ways to use a pop up calendar, but none of the ways I have found are specific to my needs.

I am using user forms that contain many fields that are filled out and then entered into different columns of a spreadsheet.

I currently have the user entering in the date manually with "mm/dd/yy" in the text box upon userform initialize to signal the desired format.

Is there a way to create a pop up calendar so the user can select a certain date, and then that date be entered into the text box?

I have attached my workbook
the password, when prompted, is "MillSteel"
I am using Excel 2010

Thanks!

I'm not sure if active cell will work.

Everything that I insert from the userform onto the spreadsheet is using row count.

I could be mistaken though.
have you looked at the workbook?

okay that makes more sense.. could you attach it and send the workbook back?

Hi that works great!

you only added the userform and the subs to call it for each different displayin(textbox)?
(I ask because I need to transfer it to the workbook actually being in use)

Also,
Is there a way to close the form upon clilcking a date? or I guess I could simply add a button to close the form?

The original code wasn't closing the form after selecting a date, so Leith changed the class module to this:

Please Login or Register  to view this content.

Thanks so much for your help!