Fix a Missing Calendar Date Picker in Excel VBA
Question details
Determine why a calendar UserForm or date-picker control is missing from an Excel VBA project and restore or replace it.

- 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.
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.
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.
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.
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.
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.
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 date-picker component compatibility and repair Office
Use this when the control is absent from Additional Controls or stopped working after an Office change.
Replace the picker with worksheet date entry
Use date validation as a simpler alternative when a compatible calendar control is unavailable.
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.

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.




