Use Calendar (Excel 2007) and the Date Picker (Excel 2010) in same project...

I have a Userform that I created in Excel 2007 with a Calendar. When I open this in Excel 2010, the Calendar isn't part of that version, so the object is removed from the Userform and I am forced to comment out the calendar script.

I have heard about the Date Picker, but I have no idea how to use it.

Is there a tool I can use to allow the Calendar to come up when the Userform is opened with Excel 2007 and the Date Picker when the program is opened using Excel 2010?

This calendar allows the user to select a date and then the information is passed to a cell where the date is filled in.

I need the script to be versatile between the two and I'm racking my brain trying to figure this out.

Any advice or direction is greatly appreciated. I have no idea where to start when trying to combine the two date options.


Here is what I've done so far on my own... My mind is very scrambled... Please help!

Please Login or Register  to view this content.