Issue on Calendar/DatePicker controls Compatiblity

[SathishKumar]

Is there any common calander/datepicker options compatible to all versions of excel?
If yes, pls respond

[jaslake]

Hi SathishKumar.

Try any this link
http://www.excelforum.com/excel-prog...-calendar.html

Go to here

There is also an example of how to use the ActiveX Calendar Control Another way would be to use ComboBoxes on a UserForm, get an example here or a UserForm calendar is available with code & examples of how to use it. Free download...

and click on Free download...you'll be able to download the File and adapt the Code from there.