Add a MonthView or Date Picker to an Excel VBA UserForm
Question details
Add a calendar or date-and-time picker to an Excel VBA UserForm when the MonthView control is missing.

- Product
- Microsoft Excel VBA UserForms
- Device & OS
- not provided
- Scenario
- The user wants a date-selection control on a UserForm, particularly in Office 2013 or a 32-bit Office installation.
- Observed behavior
- The MonthView or Date Picker control is not available in the UserForm toolbox.
In Excel, check File > Account > About Excel to confirm the Office version and whether it is 32-bit or 64-bit. The legacy calendar controls are not included with every Office installation, and 32-bit ActiveX controls cannot be used in 64-bit Office.
Add an available MonthView or Date Picker control
Use this method if the compatible legacy control is already installed and available to Excel.
In Excel, press Alt+F11 to open the VBA editor. In Project Explorer, double-click your UserForm, or choose Insert > UserForm to create one.
Show the Toolbox with View > Toolbox if needed. Right-click the Toolbox and select Additional Controls.
If listed, select Microsoft MonthView Control 6.0 or Microsoft Date and Time Picker Control 6.0, then click OK.
Click the new control in the Toolbox, draw it on the UserForm, and press F5 to test the form. Use the control's Value property in your VBA code to read the selected date.

Use a custom VBA calendar UserForm
Choose a custom calendar when the legacy ActiveX control is unavailable and you need a clickable date picker.
Use a validated date-entry textbox instead
Use this fallback if you need users to enter a date without installing a calendar control.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats, making it easy to move everyday spreadsheet work. It does not install or fix Excel's missing VBA calendar controls.

Frequently Asked Questions
Why is MonthView missing from Additional Controls?
The legacy control may not be installed, registered, compatible, or licensed for your Office installation. Check the VBA editor's Toolbox > Additional Controls; if it is absent, consider a custom VBA calendar instead.
Does 32-bit Office always include the Date Picker control?
No. Although some legacy controls work only with compatible 32-bit Office installations, 32-bit Office does not guarantee that the control is installed or available.
Can I use a 32-bit MonthView control in 64-bit Excel?
No. A 32-bit ActiveX control cannot run inside 64-bit Excel. Use a compatible custom VBA calendar or a validated date-entry field instead.
How do I check whether my Excel installation is 32-bit or 64-bit?
In Excel, open File > Account > About Excel. The dialog shows the Office version and bitness.
Can I add a date to a UserForm without an ActiveX calendar?
Yes. Add a TextBox and a CommandButton to the UserForm, then use VBA's IsDate and CDate functions to validate and convert the entered date. Input is interpreted using the system's regional settings.




