Put simply, VBA is the programming language used to write macros.Ĭheck out this explanatory video for more background on the differences between macros and VBA from the GoSkills Excel Macros & VBA course. You may have heard the terms 'macro' and 'VBA' used interchangeably, but there is a distinction.
A macro is a piece of code within Excel that you can use to automate many routine tasks-just like the ones I mentioned above.