Introduction to Properties, Methods and Parameters in Excel VBA

By

Power Spreadsheets

The main purpose of Introduction to Properties, Methods and Parameters in Excel VBA 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.

Introduction to Properties, Methods and Parameters in Excel VBA:

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

Introduction to Properties, Methods and Parameters in Excel VBA 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.