VBA Macro

Also known as · Macros

A named block of Visual Basic for Applications code, written Sub name() ... End Sub, stored in a module inside the workbook. Macro names cannot contain spaces, and the VBA editor opens with Alt+F11.

When to use

Use a macro for a repetitive task or to give a colleague a Macro Button. It can only be saved in a Macro-Enabled Workbook (.xlsm or .xlsb), and Excel blocks macros from internet files by default.

See Lec 08.

Appears in

No references yet.