How do I get an excel version that runs VBA

To get a version of Excel that runs VBA (Visual Basic for Applications), you should use the desktop versions of Microsoft Excel, specifically Excel for Windows or Excel for Mac. VBA is built into these desktop versions, allowing you to create and run macros easily.

Excel for the web does not support VBA, so if you need to work with VBA, ensure you have the desktop version installed. You can obtain it through a Microsoft 365 subscription or by purchasing a standalone version of Microsoft Office that includes Excel.

References:

• Differences between Office Scripts and VBA macros
• Compatibility between the 32-bit and 64-bit versions of Office

Hi!

Welcome to Microsoft Q&A forum.

Every full desktop version of Excel already supports VBA. If you want to run or write VBA macros, you need the desktop Excel app, not the web or mobile versions.

Here are the versions that supports VBA:

Excel for Windows (Microsoft 365 / Office 2021 / Office 2019 / Office 2016)

• Fully supports VBA
• Developer tab, VBE editor, .xlsm files all work

Excel for Mac (Microsoft 365 / Office 2021 / Office 2019)

• Supports VBA (though a few Windows-specific features aren’t available)