It should be compatible with most systems, though I haven't tested it on others than my own. I developed code that will create a dateGetter userform, get the user's date selection as a Global variable, and then delete the form. Some users may not have the ability to use your DatePicker if their Excel is not formatted correctly. In either way, you will need to implement the actions when you click on these controls. Default size of the controls on UserForm:.Now the controls are in your Controls tab to add on UserForms.Scroll down and tick Microsoft Date and Time Picker Control 6.0 (SP6) or Microsoft MonthView Control 6.0 (SP6):.

In the Toolbox for the UserForm selected, right click on empty space of the Controls tab, click Additional Controls.

When you are out of Design Mode, clicking on the DTPicker control is like this, while the MonthView takes more space:.Scroll down and select Microsoft Date and Time Picker Control 6.0 (SP6) or Microsoft MonthView Control 6.0 (SP6) then click OK.In Developer tab, Controls group, click Insert, then bottom right.Date and Time Picker ( DTPicker), left/top of screenshots.Once you have registered the mscomct2.ocx control ( YOU WILL NEED TO REGISTER THIS FILE ON ALL COMPUTERS THAT WILL USE THIS WORKBOOK!), you can either add one of below controls in the Worksheet or in a UserForm:

Add calendar date picker to excel 2013