Excel for Microsoft 365 on Windows does not include a universal VBA date-picker control that you can simply add to any cell. The old Microsoft Date and Time Picker ActiveX control may appear on some installations, but it is often unavailable or incompatible; for a dependable calendar, use a custom VBA UserForm or a trusted add-in, and use data validation when restricting date entry is enough.
What Excel’s date-picker control means
People searching for an Excel VBA date picker often mean one of three different things: a calendar displayed beside a worksheet cell, a calendar inside a VBA UserForm, or a control that can be inserted from Excel’s Developer tab. Those options are not interchangeable. A worksheet control is placed on a sheet, while a UserForm is a separate dialog that VBA opens and closes. Both need code to return the selected date to the right cell.
Excel cells store dates as numbers and display them using a number format. That makes date entry different from choosing an item from a built-in list: a calendar interface has to be supplied by a control, an add-in, or custom code. The standard Data Validation feature can limit what counts as an acceptable date, but it does not provide a calendar popup in desktop Excel.
Why the old Date and Time Picker is hard to find
The control commonly meant by “Excel date picker” is Microsoft Date and Time Picker Control 6.0 (SP6), usually associated with the legacy MSCOMCT2.OCX component. Some older Office installations have it registered, and it may be listed under Developer > Insert > More Controls. It is not a standard, guaranteed component of Microsoft 365, however. Its presence depends on the Windows installation and available component registration, not merely on which Excel ribbon tabs are visible.
Compatibility is a major limitation. The legacy control is generally associated with 32-bit environments and is commonly missing or unusable with 64-bit Office. ActiveX controls can also be restricted by Office security settings or an organization’s policy. If a control does not appear in More Controls, that does not mean Excel has a hidden setting that will reliably install it. Downloading an old OCX file or registering one from an unknown site is a poor workaround: it can create security and compatibility problems and may still fail.
How to check for an installed control
On Windows, first display the Developer tab if needed: choose File > Options > Customize Ribbon, select Developer, and click OK. Then choose Developer > Insert > More Controls and look for Microsoft Date and Time Picker Control 6.0 (SP6) or a similarly named date control. The More Controls button and the list of available controls depend on the installed Office components. If the desired item is absent, do not assume that changing a workbook setting will make it available.
Even when the control is listed, check it in a disposable copy of the workbook and on the same Office bitness and security configuration used by its intended users. ActiveX controls are not supported in Excel for Mac, and Excel for the web does not run VBA macros or worksheet ActiveX controls. A workbook that relies on a legacy control can therefore work on one Windows computer and fail for colleagues using another platform.
Choosing between a UserForm and a worksheet control
A custom VBA UserForm is usually the more maintainable VBA route when a workbook must show a calendar. The form can be designed to display a month, let the user move between months, and return the chosen date to a selected cell. Because its calendar is created from VBA form elements rather than the legacy Date and Time Picker, the workbook creator has more control over the interface. The trade-off is that the calendar must be built, maintained, and checked for date edge cases; VBA does not provide a universal, ready-made calendar form in every new workbook.
A worksheet ActiveX control can feel convenient when the calendar should remain visible on a particular sheet, but it is more tightly coupled to Windows and the installed control. It may be suitable for a controlled environment where every user has the same supported setup. For a workbook shared broadly, a custom form or a non-VBA alternative is generally less dependent on a specific legacy component.
- Choose a custom UserForm when you need a VBA calendar and can support macros and maintain the form.
- Use the old ActiveX control only when it is already available and your users’ Office installations are compatible.
- Use validation or direct entry when the important need is correct dates, not a visual calendar.
Returning a chosen date to a cell
A calendar interface and the code that writes its selection are separate pieces. In a custom form, the day-button event can calculate a valid Date value and pass it to a helper routine. The example below shows only that handoff; it does not create the calendar, buttons, or month navigation. Put it in a standard VBA module, and have the form call it with the intended single cell and selected date.
Save a copy of the workbook before running or changing VBA. Macro actions cannot be undone with Ctrl+Z.
Public Sub WritePickedDate(ByVal target As Range, ByVal pickedDate As Date)
' Write the selected date to one cell only.
If target Is Nothing Then Exit Sub
If target.Cells.CountLarge <> 1 Then Exit Sub
target.Value = pickedDate
target.NumberFormat = "yyyy-mm-dd"
End Sub
The format in this example displays an unambiguous year-month-day date, but the cell still contains a real Excel date value. A custom form should validate its day selection before calling the routine: for example, it should not offer February 30. Using a Date value or DateSerial to construct the result is safer than assembling a date as text, since text interpretation can vary with regional date settings.
What Data Validation can and cannot do
If the goal is to prevent invalid dates, a calendar may be unnecessary. Select the target cells, choose Data > Data Validation, set Allow to Date, and specify the permitted range or comparison rule. For example, a form might accept dates between a project start and end date. This checks the entered value, but it does not turn the cell into a clickable calendar. A user still types or pastes a date.
For simpler entry, give the column a clear date format and add an instruction such as “Enter a date as yyyy-mm-dd.” In Excel for Windows, Ctrl+; inserts the current date into the active cell; it is a shortcut for today, not a date-picker dialog and not a way to choose a past or future date. Shortcuts can vary with keyboard layout and platform. Excel for Mac does not support the Windows ActiveX route, so test any shortcut or VBA form in the actual Mac version used by your audience.
Macros, platforms, and sharing the workbook
VBA requires the desktop Excel application and a macro-enabled workbook, normally saved as an .xlsm file. In Windows Excel, Alt+F11 opens the Visual Basic Editor. Users must also be allowed to run the workbook’s macros under their security settings. Do not tell users to enable every macro globally just to use a date form; follow your organization’s approved macro and trusted-file practices.
Excel for the web can open many macro-enabled workbooks, but it cannot run VBA. ActiveX is a Windows technology and is not available in Excel for Mac. Some VBA UserForm behavior also differs across platforms, so a form that works on Windows should not be advertised as cross-platform without testing. If a workbook will be used in a browser, on Mac, or by external recipients, consider a non-VBA workflow instead of making date entry depend on a Windows control.
Common problems and practical fixes
- The control is missing: It may not be installed or registered, or the Office bitness may be incompatible. Prefer a supported alternative rather than downloading an OCX from an unverified source.
- The workbook opens but the calendar does not: Check whether macros are permitted and whether the control is blocked by Office security or policy. A missing control may also cause an error when the sheet loads.
- The date changes by region: Avoid sending dates as ambiguous text such as 04/05/2026. Use a real Date value and a clear display format; month/day order differs by locale.
- The wrong cell receives the selection: A form should deliberately store or receive its target cell when it opens. Relying on ActiveCell alone can write to the wrong place if the user clicks elsewhere before choosing a date.
- The calendar is clipped or awkward: Check form dimensions, screen scaling, and month-boundary behavior. Test leap years and transitions between December and January as well as ordinary dates.
Frequently Asked Questions
Does Excel 365 have a built-in date picker for cells?
No general-purpose date-picker popup is built into desktop Excel for arbitrary cells. Data Validation can restrict dates, and a control, add-in, or custom form can provide a calendar interface.
Why can’t I find Microsoft Date and Time Picker Control 6.0?
It is a legacy ActiveX control and is not included or usable in every Office installation. Its availability depends on the installed component and compatibility, including Office bitness; Excel settings alone cannot guarantee that it will appear.
Can I use an Excel VBA date picker on a Mac?
Excel for Mac does not support ActiveX controls. VBA and UserForm capabilities are a separate matter and can differ from Windows, so a custom form must be checked on the Mac versions and devices that will use it.
Will a date-picker macro work in Excel for the web?
No. Excel for the web does not run VBA macros or ActiveX controls. Users can still edit cells in a workbook there, but the VBA calendar itself will not operate.
Can Data Validation show a calendar?
In desktop Excel, Data Validation can accept or reject dates according to rules, but it does not provide a calendar popup. It is useful when preventing out-of-range entries matters more than offering a visual picker.
What is the safest option for a workbook shared widely?
Use a workflow that does not depend on a legacy ActiveX component: clear date instructions, date validation, or a supported add-in or custom solution tested on the users’ platforms. If VBA is essential, document its Windows and macro requirements.
Related
- Excel Text to Columns Wizard: Split Data Easily
- Excel Text to Columns: Why Leading Zeros Disappear
- Excel Text to Columns: What the Text Qualifier Does
Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.
More in VBA & macros
- LibreOffice Macro Recorder: Setup and LimitsYes—LibreOffice includes a built-in macro recorder, but it is limited: it captures some actions in Calc and Writer…
- Excel VBA On Error Resume Next: Safe Use and ExamplesIn Excel VBA, On Error Resume Next tells a procedure to continue with the statement immediately after the…
- VBA Code Workbook Open: How to Run Macros at StartupTo run VBA when an Excel workbook opens, put a Workbook_Open event procedure in that workbook’s ThisWorkbook code…
- Excel VBA If Statement Without Then: What Works?No: an Excel VBA If statement must include the keyword Then. Write If condition Then before the action…
- VBA Convert to String: How CStr WorksIn VBA, use the built-in CStr function to convert a value to a string: for example, CStr(42) returns…
- VBA Code to Copy a Range in ExcelIn Excel VBA, copy a range by calling Range.Copy and naming the destination range. For example, sourceSheet.Range("A1:C10").Copy Destination:=targetSheet.Range("A1")…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.