How to add pop-up calendar in spreadsheet cell

[PB-04]

Hi

How can I add calendar that pops-up on clicking on a cell in excel spreadsheet and allows to select the date. 

Thank you. 

[#2]

@PB-04 

In Excel, you can add a pop-up calendar by using the Date Picker control from the Developer tab. Here's a step-by-step guide:

Enable the Developer Tab:

1. Open Excel and go to the "File" tab.
2. Click on "Options."
3. In the Excel Options dialog box, select "Customize Ribbon."
4. In the right column, check the box for "Developer" to enable the Developer tab.
5. Click "OK" to apply the changes.

Insert Date Picker Control:

1. Go to the "Developer" tab in the Excel ribbon.
• If you don't see the Developer tab, make sure you've enabled it as described above.
2. Click on "Insert" in the Controls group.
3. In the "Form Controls" section, click on the "Date Picker" (it might be labeled as "More Controls" in some versions).
4. Your cursor will change to a crosshair. Click and drag on the cell where you want the pop-up calendar to appear.

Configure Date Picker Properties:

1. Right-click on the Date Picker control, and choose "Format Control."
2. In the Format Control dialog box:
• Under the "Control" tab, you can set the linked cell (where the selected date will be placed).
• You can also customize the date format in the "Format" section.
3. Click "OK" to apply the changes.

Use the Date Picker:

1. Click on the cell linked to the Date Picker control.
2. A small calendar icon will appear next to the cell.
3. Click on the calendar icon to open the pop-up calendar.
4. Select the desired date from the calendar.

The selected date will be inserted into the linked cell, and you can use this cell value in your calculations or data.

Note: The availability of the Date Picker control depends on your version of Excel and your system settings. If you can't find the Date Picker, you may need to use alternative methods or third-party solutions. Additionally, some Excel versions might have the "Date and Time Picker" control instead of the "Date Picker." The text and steps were edited with the help of AI.

In order to provide more help, more information is required, such as Excel version, operating system (Win., Mac, etc.), storage medium (Sharepoint, OneDrive, etc.), file extension (.xlsx, xlsm, etc.).

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

[#3]

Hi NikolinoDE,

Thank you for the quick reply with detailed instructions.
I have enabled developer tab but I don't see insert/ control group or any date picker option under the developer tab.
I am using Office 365 on MacBook Pro.
Please help. Thank you.

[#4]

@PB-04 

In Excel, you can add a pop-up calendar to a cell using the "Date Picker" control. But so far I know, Excel for Mac does not have a built-in date picker like Excel for Windows. However, you can use a workaround by creating a user form with a date picker control.

Here are the general steps:

1. Open Excel:
• Launch Excel on your MacBook Pro.
2. Enable Developer Tab:
• If you don't have the Developer tab enabled, go to "Excel" > "Preferences" > "Ribbon & Toolbar" and check the "Developer" option.
3. Open the Visual Basic for Applications (VBA) Editor:
• Click on the "Developer" tab in the ribbon.
• Click on "Visual Basic" to open the VBA Editor.
4. Insert UserForm:
• In the VBA Editor, right-click on any item in the project explorer on the left.
• Choose "Insert" > "UserForm" to add a new UserForm.
5. Add a Date Picker Control:
• In the Toolbox (if it's not open, press Ctrl + T to open it), find the "Date Picker" control.
• Click and drag the Date Picker control onto the UserForm.
6. Code the Calendar Behavior:
• Double-click on the UserForm to open the code window.
• Use VBA code to show the UserForm when the cell is clicked.

Here's an example:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Address = "$A$1" Then ' Change this to the cell address where you want the calendar
        UserForm1.Show
        Cancel = True
    End If
End Sub

• This example assumes the cell A1 is the target cell for the calendar. Adjust the code based on your specific cell.
1. Close the VBA Editor:
• Close the VBA Editor and return to Excel.
2. Test the Calendar:
• Double-click the designated cell (e.g., A1), and the UserForm with the date picker should appear.

Keep in mind that Excel for Mac might have received updates since my last knowledge, and there might be new features or changes. Of course you can still create a simple date picker using Data Validation.

Additional Link/info: Date Picker Calander Pop up in a Cell in 365 for Mac?

NOTE: My knowledge of  Office 365 on MacBook Pro is limited, I entered your question in various AI. The text and the steps are the result of various AI's put together. Maybe it will help you further in your project, if not please just ignore it.

[#5]

@PB-04 

So far for 365 built-in Date Picker exists only on Excel for web (format cell as date and double click on it). 

[#6]

I need help from someone on this topic. I read the above posts and others but nothing is even close to what I have...which is: Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bit
How do I locate and activate this so-called mysterious date picker?
Some posts had MS folks stating it's not available on free web version but I pay a hefty annual subscription fee for this Office365 suite license. Not free.
Thank you!

[#7]

@KevinStorms 

So far date picker is available only in Excel for web. For other platforms you may use third-party tools, at least there is nothing from the box at the moment.

[#8]

@PB-04 so if you haven’t already sorted it,  ive worked out, date picker is built in to 365 excel differently. 

if you highlight cells you want the dates in, right click and click on ‘Number Format…’. Select date from the ‘Category’ list and your preferred date layout from the ‘type’ list. It should then add it in with the option for a pop up calendar when you click or double click on the cell

i couldn’t find any answers just alot of the old method and people saying it can’t be done without an add in. My job blocks add in’s so this is how i got it to work. 

[#9]

Hi @EternallyConfused, Thank you for the answer.
Is it available in Mac as well? 

[#10]

Thank you @Sergei. I am looking for this feature on offline Office. Thank you for suggesting third party tools.

[#11]

Thank you for the detailed answer.
I tried this but there is no "Choose "Insert" > "UserForm" to add a new UserForm." option in the developer tab.