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.

Date Picker

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. When you click on the button with the ? you can read the information below how to insert the date or week number in the active cell.

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 2.1 for Excel 2016 released on 24-Dec-2016. 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

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

Note: This is the second version so please report problems. I open the Date Picker not vbModeless anymore in this version because the Excel team not seems to be able to fix the bugs that there are when you open userforms vbModeless in Excel 2016.

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