VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs. 1 Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros. ... A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.