Introduction to Properties, Methods and Parameters in Excel VBA

The main purpose of is to help you work with the following three (essential) VBA constructs:

• Properties;
• Methods; and
• Parameters.

These are three of the most important VBA constructs. Having a good understanding of them is essential when working with VBA.

:

• Is part of my Book Series; and
  
• Assumes you know about the topics covered in: (i) My previous Book Series, particularly the Book Series; and (ii) The previous Books in the Book Series.
  

is divided into four Chapters.

• Chapter 1 is an introduction to the following three VBA constructs: (i) Properties; (ii) Methods; and (iii) Parameters.
• In Chapter 2, you learn how to work with: (i) Properties; (ii) Methods; and (iii) Parameters.
• In Chapter 3, you learn about built-in (also known as system-defined or intrinsic) constants.
• Chapter 4 contains several practical examples to help you practice creating procedures that work with/manipulate objects using: (i) Properties; (ii) Methods; and (iii) Parameters.