Absolute Beginner's Guide to VBA

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 ...