O'Reilly logo

Absolute Beginner's Guide to VBA by Paul McFedries

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

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

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