VBA & Macro Problems

Add a MonthView or Date Picker to an Excel VBA UserForm

Tauseeq MagsiTauseeq Magsi Nov 20, 2026 869 views

Question details

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

How to Add a MonthView or Date Picker to an Excel VBA UserForm
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.
Before you start

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.

Solution 1Recommended

Add an available MonthView or Date Picker control

Use this method if the compatible legacy control is already installed and available to Excel.

1
Open the UserForm

In Excel, press Alt+F11 to open the VBA editor. In Project Explorer, double-click your UserForm, or choose Insert > UserForm to create one.

2
Check additional controls

Show the Toolbox with View > Toolbox if needed. Right-click the Toolbox and select Additional Controls.

3
Select the calendar control

If listed, select Microsoft MonthView Control 6.0 or Microsoft Date and Time Picker Control 6.0, then click OK.

4
Place and test the control

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.

Add an available MonthView or Date Picker control
Control not listed?: The control may not be installed or compatible with your Office version. A 32-bit Office installation alone does not guarantee that the control is available or licensed for use.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesEnter and format dates in spreadsheetsUse a familiar interface for everyday spreadsheet tasksMove common Office documents into a lightweight workspace
microsoft office alternative - wps office

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.