The main purpose of "Introduction to the Excel VBA Object Model and Object References" is to give you an introduction to the following two topics, which are essential for Excel VBA users:
#1. The Excel VBA Object Model; and
#2. Object references.
Objects are one of the most important VBA constructs. Having a good understanding of objects, the Excel Object Model and object references is essential when working with VBA.
"Introduction to the Excel VBA Object Model and Object References":
• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in: (i) my previous Book Series, particularly in the Excel Macros for Beginners Book Series; and (ii) the previous Books in the VBA Fundamentals Book Series.
"Introduction to the Excel VBA Object Model and Object References" is divided in five Chapters.
#1. Chapter 1 is an introduction to the importance of objects.
#2. Chapter 2 is an introduction to the Excel Object Model.
#3. In Chapter 3, you learn: (i) what collection are; and (ii) how to work with collections.
#4. In Chapter 4, you learn the basic process you can follow to refer to an object.
#5. Chapter 5 contains several practical examples to help you understand/practice how to create procedures that refer to, and select/activate, an object.