- I have created an Excel-workbook with a VBA form in it for saving information in a new sheet every time you use the form. It works brilliant on my PC, but on my friends Mac it doesn't work at all. I'll add the code here and if there's anyone out there with a good answer please let me know how to make this work on a Mac.
- Microsoft just released an update to the VB Editor for the Mac 2016 version of Excel. New features include:- Edit and debugging toolbars.- Updated Project.
In this article. Use VBA add-ins and macros that you developed for Office for Windows with Office for Mac. Applies to: Excel for Mac PowerPoint for Mac Word for Mac Office 2016 for Mac If you are authoring Macros for Office for Mac, you can use most of the same objects that are available in VBA for Office.
This Excel tutorial explains how to open the Visual Basic Editor in Excel 2011 for Mac (with screenshots and step-by-step instructions).
Download Visual Basic For Mac
See solution in other versions of Excel:
You can access the VBA environment in Excel 2011 for Mac by opening the Visual Basic editor.
First, be sure that the Developer tab is visible in the toolbar in Excel.
The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form Controls like buttons, checkboxes, etc.
To display the Developer tab, click on Preferences under the Excel menu at the top of the screen.
When the Excel Preferences window appears, click on the Ribbon icon in the Sharing and Privacy section.
Visual Basic For Mac Excel
In the Customize section, check Developer in the list of tabs to show. Then click on the OK button.
Visual Basic For Mac Excel Download
Select the Developer tab from the toolbar at the top of the screen. Then click on the Editor option in the Visual Basic group.
Visual Basic For Mac Excel Shortcuts
Now the Microsoft Visual Basic editor should appear and you can view your VBA code.