Windows 10: Microsoft Date and Time picker

I don't have Microsoft date and time picker as an option in developer. How do I get this? I have Window 11 64-bit

:)

 

how to download Microsoft date and time picker control 6.0 (sp6) in windows 10?

how to download Microsoft date and time picker control 6.0 (sp6) in windows 10?

 

Missing Date/time picker in Excel 2016

I have a new Windows 10 laptop with Excel 2016. I need to support a spreadsheet that has a datetime picker.

When I start the spreadsheet, I get an error "Could not load an object because it is not available on this machine." I go to the VBA code, and get the error "Compile error: Method or data member not found" on the line

Where and how do I get or enable the date time picker?

This might be related: Cannot use Date and Time Picker in Office 2013, but I don't even see the file mscomct2.ocx

 

how to download Microsoft date and time picker control 6.0 (sp6) in windows 10?

Dear mowaffaq,



I'm glad to see you in Microsoft Community.



May I ask how many bits your system ?



You can install the Microsoft Date and Time Picker Control 6.0 (SP6) control in Windows 10.



1. The first thing I need to explain to you is that you can register the calendar control in a 64-bit system, but it only works with 32-bit office. Even if you add the reference to mscomct2.ocx/mscal. When ocx is in Excel 64-bit, it still returns the "Cannot load object because it is not available on this machine" error.



2. If you are using 64-bit Office, to install this plug-in, you need to uninstall the 64-bit version of Office and reinstall the 32-bit version of Office, and then perform the following steps. You can click here to refer to choosing a 64-bit or 32-bit version of Office.



3. Because Excel2010 and Excel2013 are pre-installed on Windows, but Excel 2016 and later versions require you to manually download and install them on your computer.



4. Below are the steps I give you to install Microsoft Date and Time Picker Control 6.0 (SP6):

Click the Windows Start button, type mscomct2.ocx or mscal.ocx in the search box, and hit Enter.

1) If the file of mscomct2.ocx can be found

• Right-click the Start button, Windows Terminal (Admin) -> then enter the following command:

For Windows 32 bit:

For Windows 64 bit:

• Then click Enter, the file mscomct2.ocx will be successfully registered on your computer.

• Once mscomct2.ocx is registered, restart Excel, go to the "Developer" tab, click "Insert" -> "More Controls", the Microsoft Date and Time Picker control will appear.



If there is anything not clear, please do not hesitate to let me know.



Best regards,

Zoee | Microsoft Community Support Specialist