Skip to Main Content
Excel Macros For Dummies
book

Excel Macros For Dummies

by Michael Alexander
June 2015
Beginner content levelBeginner
288 pages
5h 27m
English
For Dummies
Content preview from Excel Macros For Dummies

Chapter 3

The Anatomy of Macros

In This Chapter

arrow Exploring the Excel Object Model

arrow Leveraging variables in your Macros

arrow Utilizing event procedures

arrow Handling potential errors in your macros

The engine behind macros is VBA (Visual Basic for Applications). When you record a macro, Excel is busy writing the associated VBA behind the scenes. To fully understand macros, it’s important to understand the underlying VBA typically used in Excel macros.

This chapter starts you on that journey by giving you a primer on some of the objects, variables, events, and error handlers you will encounter in the macro examples found in this book.

An Overview of the Excel Object Model

Visual Basic for Applications is an object-oriented programming language. The basic concept of object-oriented programming is that a software application (Excel in this case) consists of various individual objects, each of which has its own set of features and uses. An Excel application contains cells, worksheets, charts, pivot tables, drawing shapes — the list of Excel's objects is seemingly endless. Each object has its own ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Macros For Dummies, 3rd Edition

Excel Macros For Dummies, 3rd Edition

Dick Kusleika

Publisher Resources

ISBN: 9781119089346