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!

This entry was posted in Instructions, Troubleshooting and tagged , , , , , , , , . Bookmark the permalink.

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

  1. Ian Fife says:

    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

  2. wahtx says:

    Ian, did you run it as the local administrator?

  3. Jake says:

    Exactly what I was looking for. Thanks!

  4. Keane says:

    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

  5. HENRY says:

    THANKS.

  6. Eliana says:

    Hi
    Can I put date and hour together? is there this resource in microsoft date and time picker 6.0

  7. Val says:

    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.

  8. Mary says:

    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 says:

      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

      • Indra says:

        hey Andrew,

        i follow your suggestion, it really works great

        thank u

      • guest says:

        HI Andrew. When I type "cd WindowssysWOW64" I get "the system cannot find the path specified". The only difference between your set up and mine is that I am using Excel 2007. in hte command prompt administrator I am on path c:Windowssystem32. I am hoping you have a suggestion for what I am doing wrong. thank.

      • Magnus says:

        Only solution that worked for me and it works perfectly
        Thanks

      • James says:

        I was getting confounded because I am using 64 bit windows. This worked perfectly. Thank you very much!

  9. piyusha says:

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

  10. Lanre says:

    Thank this actually helps after installing SP4

  11. Jeremy says:

    This doesn’t work. I get the same problem as Ian and Mary. Command window pops up for a split second, then closes.

  12. Jeremy says:

    This doesn't work. I get the same thing as Mary and Ian. Command window opens up for a split second then closes.

  13. Neal says:

    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.

  14. jenny says:

    I actually unzip "Microsoft Date & Time Picker Control 6.0 (SP4)" but still cant run" MSCOMCT2.BAT "

  15. McCoy says:

    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 says:

      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.

  16. Clau says:

    McCoy

    Thank you so much for your help

    It really works great

  17. Guest says:

    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.

    Regards,
    Guest

  18. Guest says:

    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 says:

      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?

      • Tagene says:

        Ian, glad to know you were able to solve this problem. Can you share your solution as I am currently having this problem.

  19. Michael says:

    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 …..

  20. Irek says:

    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?

  21. Adam says:

    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 :-(

  22. Guest says:

    Unbelievable…how hard does this have to be!!!!!! I mean I just want to insert a calendar option.

  23. guest says:

    c:windowssysWOW64 folder — ???? Where's this folder in Win 7

  24. 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?

  25. Andrew says:

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

    I followed the instructions on this page: http://www.rondebruin.nl/calendar.htm

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

    (1) I downloaded MSCAL.OCX (http://www.gmayor.com/Zips/MSCAL.zip)
    (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.

  26. CIL says:

    THANKS!!!, SO MUCH, I NEED FOR AN APPLICATION

  27. Nice post. I learn one thing more difficult on different blogs everyday.

  28. Jimmybangs says:

    Works a treat – thanks!

  29. Sharon says:

    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!

  30. Craig says:

    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?

  31. it includes the use of Microsoft Date and Time Picker Control 6.0 as part of a UserForm.

  32. John Remmes says:

    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.

  33. Brian M says:

    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."

  34. Hammad says:

    Thanks thats what i was looking 4….

  35. It’s remarkable in favor of me to have a web site, which is valuable for my know-how. thanks admin

  36. guest says:

    genius it worked exactly as described

  37. sami says:

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

    1. download the MSCOMCT2.cab to desktop (reffer the first link “download it here”)
    2. install 7zip. extract the MSCOMCT2.cab file on the desktop.
    3. you get two files “mscomct2.bat” and MSCOMCT2.OCX.
    4. Copy MSCOMCT2.OCX to c:windowssystem32 (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…. :)

  38. sami says:

    I have added backslashes not sure why its missing (just for testing “c:windowssystem32″)

  39. sami says:

    haaa… its really missing… some bug on backslashes…. :( ..

    all, please use backslash after c: and windows…. Thank’s…

  40. Paul says:

    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:WindowsSystem32 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.

  41. Pingback: active x calendar control

  42. Dinesh M says:

    Great! Worked like charm.

  43. Michael S says:

    Sorry – you need backslashes before windows, system32 and mscom…. (the s/w pinched them above)

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>