Workshop: Coding VBA Macros in Microsoft Excel

Visual Basic for Applications (VBA) is a programming language that allows you to do almost anything imaginable within Microsoft Excel as well as other Microsoft applications. This comprehensive, 1-hour workshop provides an overview of the major capabilities of VBA and is a fantastic starting point for anyone interested in exploring VBA further. Topics covered include: the basics (selecting, copying/pasting), variables, user interface, if statements, loops, and decision support systems.

source