I need to add a Calendar Date Picker in Excel2013. I thought that this would be easy until I found that the MonthView and the DT Picker are no longer in the ActiveX menu and the links for a CAB file that supposedly contains these does not work. There are some seemingly excellent instruction docs out there, but they rely on a control that doesn't exist. I currently have a Excel Addin that does what I want, but I want to do this with VBA rather than install the Addin on every machine that will use this. Any ideas?

1. Microsoft Date And Time Picker Control 2013
2. Date And Time Picker Javascript
3. Date And Time Picker Jquery

Microsoft Date And Time Picker Control 2013

4 Answers

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:

• Date and Time Picker (DTPicker), left/top of screenshots
• MonthView, right/bottom of screenshots

Installing the Date Picker. Insert object' with Microsoft Date and Time Picker Control 6.0 (Sp6). Bit Vista and do have the Microsoft Date and Time Picker. Now I don't seem to have the Date and Time Picker Control. Now that References list shows Microsoft Windows Common Controls 6.0 (SP6). The date time picker.

WORKSHEET (ActiveX)

Date And Time Picker Javascript

1. In Developer tab, Controls group, click Insert, then bottom rightbutton for More Controls.
   
2. Scroll down and select Microsoft Date and Time Picker Control 6.0 (SP6) or Microsoft MonthView Control 6.0 (SP6) then click OK.
   
3. When you are out of Design Mode, clicking on the DTPicker control is like this, while the MonthView takes more space:
   

UserForm

1. In the Toolbox for the UserForm selected, right click on empty space of the Controls tab, click Additional Controls
   
2. Scroll down and tick Microsoft Date and Time Picker Control 6.0 (SP6) or Microsoft MonthView Control 6.0 (SP6):
   
3. Now the controls are in your Controls tab to add on UserForms
   
4. Default size of the controls on UserForm:
   

In either way, you will need to implement the actions when you click on these controls.

I have used mscomct2.ocx file to use a date picker in excel.You need to register it and can then easily use the date picker

Some users may not have the ability to use your DatePicker if their Excel is not formatted correctly. I developed code that will create a dateGetter userform, get the user's date selection as a Global variable, and then delete the form. It should be compatible with most systems, though I haven't tested it on others than my own. Give it a shot. If it works for you, give me a shout out....

Using DTPicker (Date Picker) element in VBA Excel Module makes your work unsharable. That happened to me many times. I usually share my works with mates and they weren't able to proceed whenever they have been encountered with DTPicker missing library problems.

Installing Microsoft Common Control 2 SP6 and then Register its service is not an everyone's cup of tea. So, Instead of using DTPicker element, I have developed my own Date Picker which is more convenient, easy and applicable.

here's the link to the Form File.https://www.dropbox.com/s/bwxtkw03kytcv8v/Form%20Files.rar?dl=0

Steps to use this Form

1. Import it
2. Now, in your USERFORM, in Date area (textbox), execute my form file with double-click event.

Date And Time Picker Jquery

Not the answer you're looking for? Browse other questions tagged excelvba or ask your own question.