Fix a Missing Calendar Control in Excel 2016 VBA
Question details
The user needs a way to restore or replace a missing calendar or date picker control in an Excel VBA UserForm.
- Product
- Microsoft Excel 2016 VBA
- Device & OS
- not provided
- Scenario
- A workbook created in an older Excel version is opened after Office 2016 is reinstalled.
- Observed behavior
- The Calendar or Date and Time Picker control is missing from the VBA toolbox and may be unavailable in 64-bit Office.
In Excel, select File > Account > About Excel to check whether Office is 32-bit or 64-bit. In the VBA editor, open the affected UserForm and identify which calendar or date picker control the workbook originally used.
Replace the Legacy Control with a VBA Date Entry Form
Use a standard UserForm when the old ActiveX calendar is unavailable or incompatible with your Office installation.
This approach uses a text box rather than a visual calendar, so it does not depend on the legacy Calendar or Date and Time Picker ActiveX control. Date recognition follows the system's regional settings.
Press Alt+F11 in Excel, select Insert > UserForm, and add a TextBox and a CommandButton from the Toolbox. Keep their default names, TextBox1 and CommandButton1.
Double-click the button and add this code inside its Click event: If IsDate(Me.TextBox1.Value) Then ActiveCell.Value = CDate(Me.TextBox1.Value) Unload Me Else MsgBox "Enter a valid date using your system's date format." End If
Select Insert > Module and add: Sub ShowDateEntry() UserForm1.Show End Sub. Replace UserForm1 with your form's name if it differs.
Return to Excel, select the destination cell, and run ShowDateEntry from Developer > Macros. Enter a date in the form and select the button to write it to the selected cell.

Check and Register the Existing ActiveX Date Picker
Use this option if the required legacy control is already installed and is compatible with your Office bitness.
Work with Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format support makes it easier to move everyday spreadsheet work between applications, though it does not restore Excel's missing ActiveX controls.

Frequently Asked Questions
Why did my calendar control disappear after reinstalling Office?
The legacy ActiveX control may not have been installed or registered again, or the new Office installation may have a different bitness. Check File > Account > About Excel and Tools > Additional Controls in the VBA editor.
Can I use a 32-bit Date and Time Picker in 64-bit Excel?
No. A 32-bit ActiveX control cannot run inside 64-bit Excel. Use a compatible replacement, such as a VBA UserForm with a date entry box.
Where can I check whether the control is available?
Press Alt+F11, open a UserForm, and select Tools > Additional Controls. Look for the specific Calendar or Date and Time Picker control used by the workbook.
Why does the replacement form reject my date?
The IsDate function uses the system's regional date settings. Enter the date in the format recognized by your system and try the form's button again.




