Date not populating cell

Hello,

I have a userform which requires the user to enter the date a training course was completed. Initially I used DatePicker as I was running Excel 2010 and had that working, however the workbook I am creating will be used on about a dozen machines, all of which have different versions of Excel. To avoid needing calendar Add-ins to be downloaded and installed for this feature I decided to go the vba created calendar route. I am using one I found on this forum:
http://www.excelforum.com/excel-gene...ml#post3443599

It works well for me using the example spreadsheet provided in the post but I am having some difficulty incorporating it into my code. I believe I have imported the appropriate forms and modules because I can get the date populate to the Label Box on my userform but when I try to put the Date into the spreadsheet along with other data such as name and course duration, the name and course duration populate but the date cell remains blank and execution completes without error.

I have tried playing around with the data type thinking I had some issue using the .Value attribute with a String but .Text gives me an error as does converting from String to Number format.

I will attach the workbook but for a quick look, the portion of the code I believe that is not working is in here:

Please Login or Register  to view this content.

Training Classes Example Workbook.xlsm

Thanks for your help,
Michelle

Change your Format(sDateString, "mm/dd/yyyy")
to

Please Login or Register  to view this content.

You could also change your calendar button (Remove) to have it as

Please Login or Register  to view this content.

But to each there own

Excelnoub

Originally Posted by Excelnoub

Change your Format(sDateString, "mm/dd/yyyy")
to

Please Login or Register  to view this content.

Success! I think I will go with this option. Thanks Excelnoub.