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 ...
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.
Read now
Unlock full access