Getting Started with VBA in Office for Mac 2011

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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.