Instructions,  Troubleshooting

How to Install Microsoft Date & Time Picker Control 6.0 (SP4)

In the posting “Insert a Drop Down Calendar Menu In Excel – Choose a Date!” one of the steps requires that you select the Microsoft Date & Time Picker Control 6.0 (SP4).

batch-fileLooking for it? Trying to figure out where to download it from? If it is not installed on your system you can download it here.

To unzip a CAB file simply follow the directions in the posting “A Free Alternative to Winzip or WinRar: 7-Zip

Once the file is unzipped simply run the MSCOMCT2.BAT batch file!


  • Ian Fife

    I have developed a worksheet for my department and it includes the use of Microsoft Date and Time Picker Control 6.0 as part of a UserForm. When I distributed the worksheet, a few employees have had the debugger come up when the UserForm appears because their version of excel does not have the Microsoft Date and Time Picker as an option under "Additional Controls…" on the toolbox pulldown. I tried installing the Picker using your instructions above but all that happened was it ran a command box for a split second and then nothing happened. Any suggestions? Some Microsoft Excel 2003 users have the control, others do not. Can the problem be resolved through a service pack download or some sort of Microsoft update? Or perhaps you may know what I am doing wrong when I tried running the above download. Any ideas would be appreciated!

    Thanks, Ian

  • Keane

    Unzipped the file and ran the batch file but said "Access is Denied". Tried running as Administrator too and that didn't do anything different

  • Val

    I tried to follow the above steps to insert a drop down calendar to pick a date, however after I make the box for the date to appear, it says cannot insert object. Pls. help.

  • Mary

    Hi i ran the bat file but nothing happens. The dos window opens up and closes within a sec… Ur reply is very important.. please anyone help

    • Andrew

      You're probably using a different version of Windows and/or Excel than the people on this forum.

      What worked for me, step-by-step for people as lost as I was …

      (1) I'm running Windows 7 (64-bit) and Excel 2010 (32-bit) … rumor has it Excel 2010 (64-bit) simply doesn't have a solution.
      (2) Download the .CAB file, unzip it and place the file "MSCOMCT2.OCX" in the folder "C:WindowssysWOW64" if you're running Windows 7 (64-bit) or place it in the folder "C:WindowsSystem32" if you're running Windows (32-bit). You'll get a prompt that you need to be an Administrator, accept all of that.
      (3) Click the Start-Menu, where it says "Search Programs and Files" in the little search form at the bottom of the start menu, type "cmd" … right click on the icon and select "Run as Administrator"
      (4) Now you'll have a command line opened, type "cd WindowssysWOW64" if you're using Windows 7 (64-bit) or type "cd Windowssystem32" if you're using a 32-bit version of windows. Press Enter.
      (5) type "regsvr32 MSCOMCT2.OCX", press Enter.
      (6) You should be all set … just go back to Excel, click your Developer tab, click "Insert" … "More Controls" (icon in the bottom right of the box)
      (7) Select "Microsoft Date & Time Picker" out of the menu.

      Hopefully this helps someone

  • piyusha

    Hi, I am also facing the same issue of "cannot insert object" even after appying the same method as given above.Help appreciated

  • Neal

    Worked like a charm. Only wish there was an easier way to get a colum of these dates without copying and pasting the control over and over again and changing the linked cell for each one.

  • McCoy

    Copy both the .bat file and the .OCX file to your desktop. Copy the MSCOMCT2.OCX to your system32 folder, then run the batch file "as administrator". Reopen excel and check controls. And there it was. Works great. Wish I could blank it out but looks like there has to be a date in there after you select an initial date.

    • Benjamin

      Hi McKoy, I've done as adviced above; did a MSCOMCT2.BAT download but I can't see it run. The windows just flickers and disappears pretty fast. I've equally tried the second option of copying both .bat file and the .OCX file in system32 folder, and ran it, but this didn't have the DT Control installed on to the additional ActiveX Controls. How else can I install this?

      I'm the administrator in my machine. By the way, this a windows 7 OS.

    • ahlDRO

      You have the best, the most explicit advice over this issue, and it works like wonders for me. I am running an MS Excel 2016 on my Acer Iconia TabW and this bugged me for a while until I followed your idea. I commend you for giving such clear instructions which I observed is increasingly becoming a rarity today in every advice forum today.

      Thank you so much for your concise instructions. Keep it up and more power! Your such a help!

  • Guest

    Thanks for that however when i put it on excel 2010 the addin has for name "Microsoft Date and Time Picker Control 6.0 (SP6) and does not seems to be working correctly.

    By the way for those having the problem "cannot insert object" , this is because you coding actual is preventing you from adding another object. Try removing the code and give it a try.


  • Guest

    Downloaded cab file, extracted files, manually copied ocx file to system32 folder, manually executed regservr32. Opened Excel. Under Developer tab, more contorls (AX), object not in list. Selected to manually register MSCOMCT2.OCX, and got error, "Cannot register this control.". This is Windows 7 (64-bit) and Excel 2003.

    • Ian

      Since my initial comment above well over a year ago I have had success registering the MSCOMCT2.OCX and installing the DT Picker Control on all our systems. However, as systems in our department are switching over to Windows 7 I am having a similar problem to "Guest" where the control will not register. I am guessing it has to do with the enhanced safety features on Windows 7 and restrictions on being able to download content, even if logged in as the administrator. Anyone have a solution for this?

  • Michael

    Everyone's referring to the BAT file, but I only see an OCX and an INF file. Should I rename the INF to .BAT and run it or …..

  • Irek

    In Windows 7 64-bit ocx is in c:windowssysWOW64 folder. The registry settings will depend on flavor of MSO with regards to 32- or 64-bit. Do you know if it is MSO that adds this control to the system?

  • Adam

    Having the same problem trying to register the DT picker control (MSCOMCT2.OCX ) – getting the 'cannot register this control' error. Running the batch file gets me an 'Access denied' error in the command prompt window. I'm using Win7 on a workstation at my office, the only thing I can assume is that it's due to my admin permissions, however, the IT guy can't figure it out either 🙁

  • Helen Feddema

    I copied the MSCOMCT2.OCX file to the System32 folder (after getting an Access Denied message from the .bat file). However, I still get the "Could not load some objects because they are not available on this machine" error message when trying to install an Outlook UserForm that had a DateTimePicker control on it (this userform was created on another computer, which had — long ago — had the Developer Edition of Office 2000 on it, the original source of this control).

    So it appears that just copying the .ocx file isn't enough. What else is needed?

  • Andrew

    I'm running Windows 7 (64-bit) and Excel 2010 (32-bit).

    I followed the instructions on this page:

    Apparently if you are using Excel 2010 (64-bit), you can't use this solution.

    (1) I downloaded MSCAL.OCX (
    (2) Unzipped and followed the directions in "Installation instructions for mscal.pdf"

    I don't know if this is the tool you're all talking about, but it seems to solve the issue I've been having.

  • Sharon

    Anyone know how to get rid of the drop down calendar now? It worked for a month or so and now when I open my files including the ones it worked fine in, the box contains a large red X and I can't do anything with it. Even in Design mode, I cannot select the box and delete it. HELP, please!

  • Craig

    Thanks, the calander works great – only problem is when I close excel and re-open the calander box keeps going back to it's origanal size after I have made it smaller, is there away to keep it the same size?

  • John Remmes

    I'm not sure if anyone on here got a clear resolve. You can copy the .OCX file to the computer and register it through EXCEL. Just Go to Developer > Insert > More Options > Register Control (Find where you copied the file to) This will register the file to Excel. I hope this helps.

  • Brian M

    I tried this but the batch file isn't working.

    I download the CAB to my desktop and then unzip the files out of the CAB to my desktop. I then run the batch file as administrator and MS DOS tells me, "The system cannot find the file specified."

  • sami

    Thanks Every one. great job. its works only on doing these below steps.

    1. download the to desktop (reffer the first link “download it here”)
    2. install 7zip. extract the file on the desktop.
    3. you get two files “mscomct2.bat” and MSCOMCT2.OCX.
    4. Copy MSCOMCT2.OCX to c:\windows\system32 (if the file is already there rename the old file to MSCOMCTold.OCX) and then try again.
    5. Run the mscomct2.bat (Please use run ad administrator even if you have admin rights)
    Now see the magic… works fine…. i was trying this solution for a month and finally i got it from this site…. thanks every one…. 🙂

  • Paul

    I combined John Remmes’ information with this and for me running Office 2007 on a Windows 64bit machine, this was my solution to add the Picker Control:

    Download and unzip the .bat and .ocx files.
    Place them into the C:\Windows\System32 folder
    Click on the Developer button.
    Click on Insert.
    Click on the More Controls icon.
    Click on Register Custom.
    This will default to the System32 folder.
    Double click on the MSCOMCT2.OCX file.
    The Microsoft Date and Time Picker Control will now appear in the list.

  • Rupesh

    I tried to follow instruction and was able to save mscomct2.ocx in my syswow64 folder and ran regsvr32 mscomct2.ocx from command prompt as administrator it shows successful but I cannot see microsoft date and time picker in additional control. what am I missing? am using windows 8 with 64bits and msoffice 2013. Please let me know.

  • nour

    I tried everything with ate and Time Picker Control but in vain. I really need your help. it is neither registered manually nor automatically. I am lost and I need your help in having the calendar in my excel sheet.

    Thank You

  • Abhishek

    Hi, need help,

    i have downloaded this file and still cannot installed or use the MS time picker option.
    i am using the Ms office 2010 and windows 10.

    Thank you for your kind help.

  • MSP Computer Maintenance


    I had already installed the Microsoft Date and Time picker and every time I would close out of the excel document and re-open it the picker would disappear and just a blank spot was there. I would then have to go into design mode, delete it, recreate it and then link the cell again. I had to explain this procedure and set it up for the vendors as well. It was driving me nuts. I started looked into this and discovered your installation procedure. I ran the files and fantastic, I no longer have a blank cell but I have an oversized calendar showing up. Now, the calendar still doesn’t work but I discovered that if I zoom out and back in by holding the CTRL key down and scrolling up and down on the middle mouse button that the calendar works…


    Wayne Leiser, I.T. Director
    B2B I.T. Solutions
    (941) 923-6280
    M – F: 9am – 5pm EST

Leave a Reply

Your email address will not be published. Required fields are marked *