I need help with Excel 2016 for mac. I have few excel files (created on windows) in that files I have drop down list/menu, this drop down list was created with an active-x control, on widows machines there is But on the mac machine i can't open the drop down list, when i click on it nothing happens. Apr 28, 2015 - Shift is a common modifier that slows down animations on Mac. In System Preferences, click 'Mission Control' and find the shortcut labeled.
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.
- Double-click on a day to Insert the date and the formatting.
- Use the 'Insert Date Only' button to Insert the date only, using the default or existing date format.
- Use the 'Insert Week number' button to Insert the week number.
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.
3) When you click on Change Settings the Date Picker you have the following options :
In the Settings section you can :
- Choose a Date format in the dropdown that will be used when you double-click on a day. There is also an option to add one custom Date format of your own if you can't find one that you like in the dateformat dropdown menu.
- Select the week number system that you want to use. Default = ISO Week numbers
- There is an option to AutoFit the column width after it insert the Date. Default = AutoFit
- There is an option that will open the calendar with the date selected that is in the active cell (if there is a Date in the cell) and not the default of the last date that you inserted with the add-in.
- There is a option to automatic close the add-in after you insert a Date or Week number(new in 2.1).
- You can change the language of the user interface of the Date Picker in: English, German, Español or Français on this moment. It will open in the language of your Excel version if it exists, if not it will use the English language.
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
- Open Excel 2016
- Update Excel 2016 (See button in the Help menu)
- Use Tools>Excel Add-ins... in the menu to open the Add-ins dialog
- Use the Browse button to select the add-in and choose Open
- Press OK
- Done
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.
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
Detect if the Shift, Ctrl, Alt or CMD key has been pressed
In Excel for Windows you can use the GetKeyState API to check this but on a Mac it is not so easy. below you find examples for Office for Windows and for Office for the Mac. Code like this can be very useful to run the code you want depending of the key status.
Example for Office for Windows
Excel for Windows example below for the Shift key, on top of a normal module add this :
In your macro you can use this then :
Example 1 for Office for the Mac 2011 and 2016
Thanks to DJ Bazzie Wazzie from the script forum i was able to create this VBA example. Note: it is not very fast but if you use Mavericks (10.9 or higher) and Office 2011 you can use the second example on this page if the speed is important.
You can run the macro named TestKey below to test it, do not forget to copy the function KeyPressedCheck inside the same module because it is called by the macro. In the function call in the macro you see that I use argument 1 for testing the Shift key now, see the comments in the macro for using argument 2, 3 or 4.
Note: When you call the function from a userform button or button on a worksheet the Ctrl key test is not working, when you run the Ctrl test from the macro dialog it is working. Reason is that Ctrl + click is right click on a Mac so the Ctrl test is only working from the macro dialog.
Example 2 for Office for the Mac 2011
Note : This example is not working in Excel 2016, example 1 is also working in Excel 2016
Thanks to Shane Stanley from the script forum I was able to create this VBA example. Note: you must run Mavericks (10.9 or up) on your Mac if you want to use this example. This example is much faster then the first example on this page but you need the extra script bundle file (checkModifier.scptd).
When you want to test the code in the Excel file the script bundle file (checkModifier.scptd) must be in the same folder of the workbook or add-in because the VBA code call this script file to get the info we need. You can change the vba code if you want to place the script bundle file (checkModifier.scptd) into another folder on your Mac.
This is the VBA code that you see in the Excel workbook and it will work if the the script bundle file (checkModifier.scptd) is in the same folder. Important: do not change anything in the script bundle file.
Note: When you call the function from a userform button or button on a worksheet the Ctrl key test is not working, when you run the Ctrl test from the macro dialog it is working. Reason is that Ctrl + click is right click on a Mac so the Ctrl test is only working from the macro dialog.
If you have suggestions or have problems please let me know.