Difference No. 4: Visual Basic for Applications (VBA)
VBA (Visual Basic for Applications) is the programming language of Excel (more precisely, Microsoft Office). It is used not only in Excel but for Word, PowerPoint, and other Microsoft applications too.
You can use VBA to develop macros in Microsoft Excel. This takes some advanced coding skills. And most basic users would simply record macros instead.
The good news! Excel on Mac supports VBA. 😊
The bad news! The VBA for Excel on Mac has many drawbacks and missing functionalities. All of this makes it way difficult to use the Mac version of VBA, as compared to its Windows counterpart.
Here’s a list of all that VBA in Excel on Mac misses out on.
1. USER FORM
Excel for Mac doesn’t allow users to create or edit user forms, very easily. Not that you cannot build them at all, but that it takes too much undue effort. And the process to create user forms on Mac is way more tedious than you’d expect it to be.
Even if you build user forms on windows and export them to Mac to see if they look fine, there might be many size issues.
A user form created in windows, which looks fine, will only come out to be 75% of its size in Mac. This makes the user forms nearly unreadable on Mac.
2. PROPERTIES WINDOW:
The VBA Properties window is not available on the Mac version of Excel.
3. IMPORT/EXPORT of VBA Codes
If you are a developer who has a lot to do with VBA codes and has many of them developed already – reconsider your decision of heading to an Apple store to get yourself a Mac Book.
Excel on Mac doesn’t allow importing/exporting VBA codes very easily.
4. VISUAL BASIC EDITOR
The Visual Basic Editor feature of Excel on Mac is way poorer than its windows counterpart.