An Microsoft Excel VBA Date Picker module that totally replaces Microsoft Calendar OCX Control and having the same functionalities and allows for configuration to input and output different types of Dates format.
Must be able to take the current date value from a Cell, shows this date in the Calender pop up.
Allow the user to pick a day and pass on this parameter to other modules or return to the Cell.
Must be able to output dates in various format e.g. dd/mm/yy, ddd/mmm/yyyy, mm/dd/yy, mmm/ddd/yyy
Must be able to test and reject errors e.g. 31/Feb/2011 and must cater for Leap Year.
Allows this module to be called from other module/ embed in other Forms.
Able to work with Excel 2003, 2007, 2010