Logo: TechTrax...brought to you by MouseTrax Computing Solutions
Member's Articles

A Touch of Class—Creating Classes in VBA

by David Horowitz

Skill rating level 8.

You may have heard about Classes in VBA (and other languages), but not know what they are or how to use them. Let's find out!

We'll examine:

  • What a Class Is
  • What the Different Elements of a Class Are
  • How to Create a Class Definition
  • How to Instantiate a Class Object
  • How to Create a Class Method
  • How to Use a Class Method
  • How to Create a Class Constructor and a Class Destructor
  • When the Constructor and Destructor Get Called
  • Places to Go From Here

If you already know something about Objects, and the use of the New and Nothing keywords, you'll have a head start.

Members, click to read...

Click to rate this article.

Go up to the top of this page.
This site powered by the Logical Web Publisher™: Content management by Logical Expressions, Inc.