How to Write Your Own Objects in Excel VBA
In this article, we will be discussing how to create a new Class Module in VBA and add our object properties and methods.
First, for those of you not familiar with object-oriented lingo, an object is a code construct comprised of properties and methods. Properties are variables that describe the object in some way; [...]
How to Write Subroutines Using VBA in Excel
Custom code, when using Excel and VBA, is written in functions and subroutines. We will be attaching our custom code to Excel’s main program and invoking our code within cell formulas or in response to certain events that occur inside Excel. One of the main things you need to remember is that the VBA procedures [...]
