VBA & Macro Problems

Fix a Missing Calendar Date Picker in Excel VBA

Muhammad TalhaMuhammad Talha Nov 14, 2026 868 views

Question details

Determine why a calendar UserForm or date-picker control is missing from an Excel VBA project and restore or replace it.

Fix a Missing Calendar Date Picker in Excel VBA
Product
Microsoft Excel VBA
Device & OS
not provided
Scenario
A workbook uses a VBA UserForm or date-picker control to select dates.
Observed behavior
The calendar UserForm or date-picker control is missing or unavailable in the VBA project.
Before you start

Identify whether the entire UserForm is missing or only the date-picker control on it. In Excel, check File > Account > About Excel for the Office version and whether it is 32-bit or 64-bit.

Solution 1Recommended

Check the VBA project and missing references

Use this first when a calendar form or its control no longer appears or the project reports a missing reference.

1
Open the project

Open the workbook in Excel, press Alt+F11, and choose View > Project Explorer. Expand the workbook's VBA project and its Forms folder to look for the calendar UserForm.

2
Inspect references

In the VBA editor, choose Tools > References and look for entries marked MISSING. Note the missing component; if it is no longer needed, clear its checkbox. Otherwise, install or restore the required compatible component before selecting its reference again.

3
Check available controls

Open the UserForm in the VBA editor, then right-click the Toolbox and choose Additional Controls. Look for the calendar or Microsoft Date and Time Picker control and select it if it is available.

4
Restore a missing form

If the entire UserForm is absent and you have its exported .frm file and any associated .frx file, choose File > Import File in the VBA editor and select the .frm file.

Check the VBA project and missing references
A reference is not the same as a control: Clearing a missing reference does not restore a missing ActiveX control. Code that depends on the reference may need the component or a replacement.
Free Microsoft Office alternative

Manage Excel workbooks with WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Excel formats, making it easy to move everyday workbook tasks. It does not repair Excel ActiveX controls, and VBA or date-picker compatibility should be tested separately.

Enter and format dates in a familiar spreadsheet interfaceOpen and save common Microsoft Excel formats, including XLSXUse a free, lightweight office suite for everyday workbook editingMove existing spreadsheets to WPS while checking advanced features for compatibility
microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel date picker disappear after an update?

An update or Office change may leave a legacy ActiveX component unavailable or incompatible. Check Tools > References and the UserForm Toolbox > Additional Controls in the VBA editor, then verify the component against your Office version and bitness.

Can I use an old date-picker control in 64-bit Excel?

Only if the control supports 64-bit Office. Many legacy ActiveX date pickers do not. Check File > Account > About Excel for your Office bitness and consult the component provider for compatibility.

How do I restore a missing VBA UserForm?

In the VBA editor, open View > Project Explorer and expand the workbook's Forms folder. If the form is absent and you have its exported .frm file and any associated .frx file, use File > Import File to import the .frm file.

Does Excel date validation add a pop-up calendar?

No. Data > Data Validation can restrict entries to dates or a date range, but users must enter the date themselves. A compatible custom UserForm calendar can provide a visual picker.