Date picker calendar on userform showing Error

Hello Experts,

I have Excel 2013 & 2010 version I couldn’t found the date and time picker on it so I search for the alternative option for date picker and I found this site I got two excellent date picker through the userform to pick the date to works on all version

1. Test date picker file is everything works fine but when I add new close button to close the date picker I am getting error on code and on cell its placing the time value I don’t know why can you please solve this error where it’s gone wrong. Please refer the attachment

2. New calendar test file I got on this site http://sites.google.com/site/e90e50/...-control-class I have two kind of date picker if Isdate double click on cell the calendar will pop up to select date but I need on the click the button (calendar date picker form) to pick the date. Another button (calendar test form) I can only see the form but I can’t edit or select the date to the cell.

Please anybody can help to solve this problems.

Originally Posted by AlphaFrog

Try this...

Hi AlphaFrog,
Sorry for the late reply and thanks for your time taken. I will check the file in office and come back to you

Hi AlphaFrog,

sorry for late reply i checked your file its working perfectly thank you so much for your effort and your time thanks a lot my friend.