How to add pop-up calendar in spreadsheet cell

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.