VBA and Macros in Excel - Explained

VBA (Visual Basic for Applications) is the programming language of Excel that allows you to automate tasks utilising what we call macros. Basically, VBA is the tool we use to develop programs to control and automate functions in Excel.

Well probably the best way to understand it, is to see how its done.