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.

Here are the steps that we’ll cover in this guide to help you get started with VBA in Office for Mac 2011.

Step 1 - Start with the Macro Recorder

Step 2 - Read and Understand the Code

Step 3 - Learn Programming Fundamentals

Step 4 - Share Your Macro with Others

Step 5 - Real World Examples

Connect with an expert
Contact us
Expand your skills
Explore training

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.