The purpose of this article is to introduce various capabilities of a class property. It is not meant to serve as an introduction to classes and objects. See the references section for introductory pages.
The typical use of a Class Property is to assign a value or to query its value as in the [...] Read...
The "wrong" way: Sub FindTotals()
Dim rCell As Range
For Each rCell In Sheet1.Columns(1).Cells
If Left$(rCell, 5) = "Total" Then
'Do...
Red wants to have a kind-of lottery for his students. He will award them prizes based on a random drawing, but wants to weight each student based on the number of assignments turned in. Normally, I would accomplish this by typing the name of each student in column A one time for every [...] Read More...