5. Working with Objects

In This Chapter

• Understanding what objects are and why they're important

• Learning to work with object properties, methods, and events

• Assigning an object to a variable

• An easy way to work with objects that have multiple properties or methods

• Taking a close look at your first two objects: the Application object and the Window object

Many of your VBA procedures will perform calculations using simple combinations of numbers, operators, and the host application's built-in functions. You'll probably find, however, that most of your code manipulates the application environment in some way, whether it's formatting document text, entering data in a worksheet range, or setting application options. Each of these items—the ...

Get Absolute Beginner's Guide to VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.