How to install Microsoft Date and Time Picker Control 6.0 (SP6) in Window 8
Question
Wednesday, March 1, 2017 5:06 AM
Dear all,
I using Excel Version 2013 and trying create calender in Excel (drop-down and printable). I tried what I found from websites
Go to Start\All Programs\Accessories.
* Right-click Command Prompt and then click on Run As Administrator.
* Change directory to the folder where you extracted the files. For example, type the following and then press Enter: cd c:\windows\system32
* Type the following and then press Enter: regsvr32 mscomct2.ocx
or
For Windows 32 bit:
C:\Windows\System32\regsvr32.exe mscomct2.ocx
For Windows 64 bit:
C:\Windows\SysWoW64\regsvr32.exe mscomct2.ocx
All cannot be use.
Anyone can help me?
Thanks!
All replies (12)
Thursday, March 2, 2017 6:56 AM
Hi Ms Nis,
Before going further, could you please provide the bit version information of both your Office and Windows? You can collect the version of Excel via File > Account > About Excel.
As far as I know, MSCOMCT2.OCX works only on 32-bit systems, so if you are using a 64-bit version of Office, then you won't be able to install the control.
If you are running 32-bit version of Excel, generally we could take the steps you have mentioned in your thread to register the calendar control in your system.
I tested in my current Excel 2013 (32-bit) and Windows 10 (64-bit) by following the detailed instructions in the article below and the control can be registered properly:
Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.
Hope the above information can be helpful.
Best regards,
Yuki Sun
Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
Wednesday, March 29, 2017 2:39 AM
Hi Ms Nis,
I am writing to see if the reply above is helpful. Please feel free to let me know if the issue still exists.
Regards,
Yuki Sun
Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
Wednesday, April 12, 2017 2:49 AM
Hi Ms Nis,
Just checking in to see if you still need assistance on this.
Best regards,
Yuki Sun
Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
Tuesday, June 6, 2017 1:27 AM | 1 vote
Hi Yuki Sun
Any alternative for Office 64?
Thanks
Friday, July 21, 2017 7:50 PM | 1 vote
I found an ugly old xlam that works on Office 2016 64-bit and is free.
Google "ron de bruin datepicker"
I add my voice to the call for a good 64-bit mscomct2.ocx
Thursday, February 1, 2018 2:30 PM
hello
i,m chris
thanks for the ron de bruin date picker heads up
worked for me.
Wednesday, May 16, 2018 6:43 AM
I did exactly as it is described. But still not showing the option Microsoft Date and Time Picker.
Thanks
Motashim
Wednesday, May 16, 2018 6:44 AM
I did exactly as it is described. But still not showing the option Microsoft Date and Time Picker.
Thanks
Motashim
By the way, my OS is Win 10.
Motashim
Monday, August 6, 2018 3:42 PM
The important part would be of you are having X86 or x64 AND if your Office is X86 or x64.
But if you do have x64 then read what has already been written!
...ich bin der Jäger des Mondes, bis der Morgen erwacht!
Monday, February 4, 2019 6:57 PM
Hi, I have Win10 x64 Home(1809- 30/Dec/2018 / 17763.292) and MS Office Standard 2016. I have same problem. I dont see time picker (I loaded .ocx and try other solution with video, doc...). I have micsrostation vb, There has a time picker but not working in excel VBA). My Company computer have Win10 Xp Pro X64 and MS Office 365. I didnt load any *.ocx file but this computer is working with time picker!!!! I want to work with time picker on my computer(Win10 x64 Home(1809- 30/Dec/2018 / 17763.292). Can you help me????
Friday, March 15, 2019 3:54 PM
Hi, i am using Excel 2016 64 bits. How can i install Date and Time Picker Control?
Tuesday, August 6, 2019 8:33 PM
neither am I could do this (Windows 10 x64 and Office 2019 x64).
But I found the best alternative right here :)
https://www.youtube.com/watch?v=5pdcLTwkn5s
Cheers!