I have not looked at your code. I have a 'DatePicker' done entirely in VBA in the attached file adapted from another person's original code. The other person did all the HEAVY lifting.
You should be able to adapt what I've done for your needs. Click on the 'Test Calendar Form Using UserForm1' button in Sheet 'Main' to see the 'DatePicker' in action with a very simple UserForm.
The function you want to use is 'LjmGetDateUsingCalendarForm()' in module 'ModLJMPicker'. It explains what resources are needed to port the 'DatePicker' to your application.
Good luck.
Edit: Added for Lewis - September 2, 2015:
The file associated with this post can still be used, but is valid for US dates ONLY.
Bookmarks