What is VBA?

Visual Basic for Applications (VBA) is a programming language primarily found in Microsoft Office products (Excel, Word, PowerPoint, Access etc.), and serves mainly as a tool for automating workflows. It helps take repetitive and sometimes complicated tasks prone to human error, and executes them for you. A well thought out VBA script can not only save you a lot of time but can also drastically improve the accuracy for your work.

For a deeper dive in VBA please read my next article, Introduction to VBA