MS-Excel / General Formatting

The Is Operator

When you looked at comparison operators in the last tutorial, the operands you used were simple numbers and strings. Indeed, most of the comparison operators don't make sense in the context of objects (for example, it's absurd to think of one object being "greater than" another). However, VBA does have a comparison operator specifically for objects-the Is operator:

result = Object1 Is Object2

Here, Object1 and Object2 are objects or Object variables. If they're the same object, result takes the value True; otherwise, result is False.

[Previous] [Contents] [Next]

In this tutorial:

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