VBA & Macro Problems

Fix a Missing Calendar Control in Excel 2016 VBA

Steven ParkerSteven Parker Nov 18, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Create a UserForm

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.

2
Add date validation

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

3
Add a macro to open the form

Select Insert > Module and add: Sub ShowDateEntry() UserForm1.Show End Sub. Replace UserForm1 with your form's name if it differs.

4
Enter a date

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.

Replace the Legacy Control with a VBA Date Entry Form
Update existing code: If the workbook refers to the old control, update those VBA references to use the new form or its text box.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX files.Enter and format dates in spreadsheets using familiar tools.Use a lightweight, easy-to-navigate Office interface.Move common spreadsheet tasks from Microsoft Office with format compatibility.
microsoft office alternative - wps office

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.