Fix Missing Microsoft Calendar Control in 64-Bit Office 2021 Excel
Question details
The user is unable to find or use the legacy Microsoft Calendar control in Excel VBA Additional Controls when running the 64-bit version of Office 2021.
- Product
- Microsoft Excel 2021 (64-bit)
- Device & OS
- Windows 11
- Scenario
- Trying to insert a date picker or calendar OCX control into an Excel worksheet or VBA UserForm via the Developer options.
- Observed behavior
- The Calendar control is missing from the Additional Controls list due to the fundamental incompatibility between older 32-bit legacy OCX controls and the newer 64-bit architecture of Office 2021.
Verify whether you are currently running the 32-bit or 64-bit version of Office 2021 by opening Excel, navigating to File > Account, and clicking on About Excel.
Use the Mini Calendar and Date Picker Add-in
Since legacy OCX calendar controls are natively incompatible with 64-bit Office, using a modern add-in from the Microsoft Store is the most reliable and recommended workaround.
Modern Office versions support web-based add-ins that bypass the architecture limitations of old OCX files. The Mini Calendar and Date Picker add-in is officially available and works flawlessly on 64-bit systems.
Open your Excel workbook, navigate to the Insert tab on the ribbon, and click on Get Add-ins.
In the Office Add-ins store window, type 'Mini Calendar and Date Picker' into the search bar and press Enter.
Click the Add button next to the add-in. The modern calendar control will be inserted directly into your active worksheet.
If you do not want to use an add-in, you can simply insert a standard UserForm Text Box and use the VBA NOW() function to capture date inputs without relying on external controls.
Manually Register the Legacy OCX File
If you possess the legacy calendar OCX file (such as mscal.ocx or mscomct2.ocx) and must use it, you can attempt to register it manually on Windows 11.
Install the 32-bit Version of Office 2021
If your workflow heavily relies on older Calendar and OCX controls that cannot be replaced, reinstalling the 32-bit version of Office will restore native compatibility.
Try WPS Office for Seamless Spreadsheet Management
Tired of dealing with legacy control compatibility issues in Microsoft Office? WPS Office is a free, lightweight, and highly compatible alternative that offers a familiar interface, ensuring a smooth transition for all your spreadsheet tasks without heavy system constraints.
Frequently Asked Questions
Why is the Microsoft Calendar control completely missing in Office 2021?
Legacy OCX files, such as the Microsoft Calendar control (mscal.ocx) and Date Picker, were built using 32-bit architecture. Modern Office 2021 defaults to a 64-bit installation, which is fundamentally incompatible with these older 32-bit controls.
Can I force the MSCOMCT2.OCX Date Picker to work in Excel 64-bit?
No, standard 32-bit OCX controls cannot be executed directly within the 64-bit Office environment. You must either use alternative modern add-ins, use form controls like Text Boxes, or switch entirely to the 32-bit version of Office.
Where do I find Developer controls in Excel?
First, enable the Developer tab by going to File > Options > Customize Ribbon and checking the Developer box. Then, navigate to the new Developer tab on your ribbon, click Insert in the Controls group, and click the wrench and hammer icon for More Controls.
Does WPS Office support VBA and macros?
Yes, the premium version of WPS Office includes robust support for VBA and macros, providing a highly compatible environment for users who rely on advanced spreadsheet automation and custom workflows.
