O'Reilly logo

Excel® VBA: 24-Hour Trainer by Tom Urtis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 1. Introducing VBA

Welcome to your first lesson in Visual Basic for Applications! A good place to start is at the beginning, where you'll find it useful to get an understanding of where VBA came from and what VBA is today. Once you get a feel for how VBA fits into the overall Excel universe, you'll learn how to use VBA to manipulate Excel in ways you might never have thought possible.

WHAT IS VBA?

Visual Basic for Applications (VBA) is a programming language created by Microsoft to automate operations in applications that support it, such as Excel. VBA is an enormously powerful tool that enables you to control Excel in countless ways that you cannot do manually.

In fact, VBA is also the language that manipulates Microsoft Office applications in Access, Word, PowerPoint, and Outlook. For the purposes here, VBA is the tool you'll use to develop macros and manipulate the kinds of objects you will learn about in this book to control Excel, and to control other Office applications from Excel.

You do not need to purchase anything more than the Office suite (or the individual application) to also own VBA. If you have Excel on your computer, you have VBA on your computer.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required