Visual Basic for Applications (VBA) in Office for Mac 2011 is a powerful, easy to use programming tool, which helps you automate repetitive tasks that you may often perform in your favorite Office app. For example, have you ever changed the style of a paragraph at the top of each page in Word, but not once, but tens of times or more? With VBA, almost any format or editing change that you do by hand can be done in VBA.
This guide will help you create your first Office automated VBA script, also known as a macro. It’ll also walk you through the code that you create, and point you to additional resources to help you go deeper with VBA.
Let’s begin by creating our first macro with the Macro Recorder.