New VB Editor for Excel 2016 for Mac - Excel Campus
2

New VB Editor for Excel 2016 for Mac

Bottom line: A new updated VB Editor has just been released for Excel 2016 for Mac to make it easier to write VBA Macros.

Skill level: Beginner

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Big Update to the VB Editor for Mac

I know many Mac users have been waiting along time for this, and I’m excited to share that an update to the VB Editor is finally here!

Microsoft just released a new build of Excel that contains a new VB Editor, which we use to write VBA macros in Excel.

The new VB Editor contains a lot of the features we are used to seeing in the Windows versions of Excel, or Excel 2011 for Mac.

In the video above I highlight some of the many new improvements to the editor.  Here is a list of the major new features.

  • Intellisense drop-down menus for auto-filling code.
  • Toolbars with buttons to for commands like: indenting, comment blocks, run, reset (stop), step into, etc.
  • VBA Project, Properties, Immediate, Locals, and Watch windows.
  • Debugging features and options.
  • Keyboard shortcuts listed next to each command on the top menus.

VB Editor Excel 2016 for Mac Features Update

This new VB Editor feels a lot more like the VB Editor we are used to on the Windows version of Excel.

The one notable feature that is missing right now is userforms.  The latest version (7.1) does not have any features that allow you to create, modify, or even view an existing userform.  I’m hoping that will be updated in the near future as well.

Even with the absence of userforms, this new VB Editor is a huge leap forward.  If you are a Mac user, you will now be able to write macros to help you automate Excel and save time with your job.

If you are new to macros or want to learn more, checkout my upcoming free webinar on The 7 Steps to Getting Started with Macros & VBA.

Macros and VBA Webinar Banner - Oct 2017 - 550x200

Get the Office Insiders Fast Pre-Release Build

To get the updated version you will need to be on an Office 365 subscription and on the Office Insiders Fast Program.  That program is free to join and open to everyone.

It allows you to download and install pre-release builds of Excel.  The latest build is 16.6 at the time of this writing, and it includes PivotCharts and a new VB Editor for writing VBA macros.  Two awesome updates for Mac users.

How to Get Office Insiders Pre-release Builds of Excel for Mac Video Thumb

Checkout my video on how to join Office Insiders and get the pre-release version.  It’s really easy to do!

Help Microsoft with Feedback

As part of the Pre-release Program, Microsoft would love to get your feedback on how to make pivot charts better.

If you find any bugs or have any suggestions you can provide feedback by:

  1. Clicking the smiley face icon in the top-right corner of Excel.
  2. Click the “Tell Us What Can Be Better” option.
  3. Complete the form and hit Send.

The Excel development team will receive the feedback and use it to make Excel even better.

If you are excited about this update, please leave a comment below and let us know.  Thank you! 🙂

Please share
Jon Acampora
 

Welcome to Excel Campus! I am excited you are here. My name is Jon and my goal is to help you learn Excel to save time with your job and advance in your career. I've been an avid Excel user and VBA developer for 10+ years. I am also a Microsoft MVP. I try to learn something new everyday, and want to share this knowledge with you to help you improve your skills. When I'm not looking at spreadsheets, I get outdoors and surf. :) more about me

Click Here to Leave a Comment Below 2 comments
Lado - October 12, 2017

Dear mr. Acampora,

do you maybe know, if VBA could be implied in IOS version too

thanks in advance

Best Regards,

Lado

Reply
    Jon Acampora - October 12, 2017

    Hi Lado,
    Unfortunately we cannot run VBA macros on the mobile (iOS or Android) or web versions of Excel. Creating apps on those platforms will require using the new JavaScript APIs. I’ll do a post on that in the future.

    Reply

Leave a Reply:

Free Webinar: 7 Steps to Getting Started with Macros & VBA

x