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

Download Mac Date Picker add-in version 3.0 for Excel 2016 released on 28-Jan-2018. 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.

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

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

Note: Please report problems if you have. Version 3.0 will also work in Mac Excel 2016 version 16. In the Spanish language version I need a few translations for version 3.0, will update the add-in when I have them. Also in 16.9 there are a few problems with buttontiptext, it seems to be fixed in 16.10 that is released soon.

Note: There is also a version for Excel 2007-2016 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.

 

Date Picker for Excel 2011

1. Download Mac Date Picker add-in version 1.0 for OS X 10.9 and higher released on 31-Aug-2014. 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.

Double-click the dmg file if it does not mount automatically. Drag the MacDatePicker.xlam file and the checkModifier.scptd to the folder you want. Important that both files are in the same folder. Tip: Use one folder for all your add-ins (easy to backup your add-ins this way)

2. Start Excel and open a workbook.

Click Tools, click Add-Ins, use "Select" to browse to and select the add-in and then
click Open. Verify Mac Date Picker is checked in the add-in list and then click OK.

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

Note: If you get a Automation error when you want to open the Date Picker you must change the region on your Mac in System Preferences>Language & Text.....Region. Seems that some regions (for example Malaysia) give problems, change it for example to United States and test it again. Do not forget to close and reopen Excel before you try it again. Please mail me the name of the region if you got problems so I can make a list with problem regions. I hope I can find a workeround for this Mac problem soon.

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

 

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. Note: if you use the 2016 version it must be MacDatePicker2016.xlam

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