Page 3 of 24PREVNEXT

Get in the loop with Excel macros

VBA macros stored inside modules

Modules are containers for storing macros, which are written in VBA.

The macro code language for most Office programs, including Excel, is Visual Basic for Applications (VBA). You may have recorded macros in Excel by stepping through actions that the program saves for you. When you record a macro, Excel records the VBA code describing your actions in a module attached to the workbook. Think of a module as a container for a number of macros. Would that be easier to remember as a list of definitions?

  • macro: a bit of code that produces a specific effect and has its own name
  • VBA: Visual Basic for Applications, the code language of macros
  • module: a container for storing macros, attached to a workbook
Page 3 of 24PREVNEXT