VBA Version

Question

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.

Answer 1

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.

Answer 2

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.

Answer 3

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.

Answer 4

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.

Answer 5

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.