Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Date Picker Add-in for Excel for the Mac

Note: There are 4 languages supported on this moment :English, German, Espa˝ol and Franšais.

 

Right click on a worksheet cell and click on the Date Picker menu option to open the Date Picker.

Information

1) You can select any month and year with the arrow keys and click on Today to jump to today's date.

2) You have an option to insert a Live Calendar to your worksheet, click on the "Insert Live Calendar" button, the screenshot below is for the ISO week number system. If you change the date on top of the calendar it will update the calendar automatic.

live calendar

3) When you click on Change Settings the Date Picker you have the following options :

In the Settings section you can :

 

Download and Install information

 

Date Picker for Mac Excel 2016 and higher

Download Mac Date Picker add-in version 3.2 for Excel 2016 and higher released on 16-Nov-2020. Many thanks to John McGhie, Mourad Louha, Sergio Alejandro Campos and Bernard Rey for the translations of the button captions and msgboxes in the add-in.

Note: Version 3.2 will postion the userform in the center of the Excel window, also with more then one screen attached to your Mac. And 3.2 is also working in macOS Big Sur.

How to install the Add-in after you unzip it on your Mac

Note: If you copy the Add-in in the Add-ins folder it will be automatic in your Add-ins dialog list, for finding this folder see : Setup your Mac for Mac Office 2016 or higher

Right click on a worksheet cell and choose Date Picker to open the userform.

Note: There is also a version for Excel 2007 and higher for Windows, click here to go to the page for Windows.

Note: The add-in is available as freeware. But you can use the Contact button in the menu if you want to support the development of this Date Picker add-in.

 

Open the Date Picker with VBA code

You can use the macro below to open the Calendar instead of using the menu item in the Cell menu.

 Sub CallDatePickerFromOtherWorkbooksOnMac()
    Dim TestWkbk As Workbook
   
    Set TestWkbk = Nothing
    On Error Resume Next
    Set TestWkbk = Workbooks("MacDatePicker.xlam")
    On Error GoTo 0
   
    If TestWkbk Is Nothing Then
        MsgBox "Sorry the Mac Date Picker add-in is not open."
    Else
        Application.Run "'" & TestWkbk.Name & "'!OpenDatePicker"
    End If
   
End Sub