Home / MS-Excel / General Formatting

Working with Objects

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 document, the range, the application-is called an object in VBA. Objects are perhaps the most crucial concept in VBA programming, and I will explain them in detail in this tutorial.

In this tutorial:

  1. What Is an Object?
  2. The Object Hierarchy
  3. Working with Object Methods
  4. Handling Object Events
  5. Working with Object Collections
  6. Assigning an Object to a Variable
  7. The Is Operator
  8. Working with Multiple Properties or Methods
  9. Example: The Application Object
  10. Example: The Window Object