Share via

VBA Version

Anonymous
2015-07-12T05:59:23+00:00

What is the version number of VBA in 2016?

Office 2011 had VBA6, as opposed to Office 2010 for Windows, which had VBA7.

I'm trying to write code that runs on both Windows and Mac.

Regards,

Shane.

Microsoft 365 and Office | Install, redeem, activate | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

5 answers

Sort by: Most helpful
  1. Anonymous
    2015-07-16T07:43:10+00:00

    Thanks. I haven't been able to find any statements from Microsoft on why the Visual Basic Editor has been scaled back. If you have seen something, please let me know.

    I thought that Mac OS was 64-bit, so I assumed that Office 2016 was come in a 64-bit edition. Good to know it doesn't.

    Regards,

    Shane.

    Was this answer helpful?

    0 comments No comments
  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2015-07-15T17:54:07+00:00

    The version of VBA in Office 2011 is about 6.5 with modifications to match the Office for Mac Object model, support AppleScript and some other variations. It is not a 1:1 exact match with VBA for Office for Windows, but it is 95-99% the same.

    The same version of VBA from Office 2011 is in Office 2016. There is a small addition in VBA to support slicers in Excel. There is a drastic cut in that the Visual Basic Editor has been cut from Word, Excel, and PowerPoint and replaced by a terrible little stubby.

    Office for Mac remains 32-bit only.

    Was this answer helpful?

    0 comments No comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2015-07-15T17:49:48+00:00

    I was not able to find the version information of VBA in 2016 but I am sure codes that work on windows will not work on mac using office 2016. It's still the same way as previous version of office mac used to work.

    This statement is absolutely false. Please remove this comment. Thank you.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2015-07-13T05:17:07+00:00

    I'm not sure what you mean by "codes".

    Office 2011 was a version behind. Office 2010 for Windows had VBA version 7, but Office 2011 for Mac had the previous version, version 6. So if I wanted a program to work in both Windows and Mac, I would have to write it in version 6.

    I was wondering if Office 2016 had caught up yet.

    Shane.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2015-07-13T02:53:39+00:00

    I was not able to find the version information of VBA in 2016 but I am sure codes that work on windows will not work on mac using office 2016. It's still the same way as previous version of office mac used to work.

    Was this answer helpful?

    0 comments No comments