Basic understanding of classes

**amphinomos** · 01-19-2016, 02:59 PM

Hi,

I've gotten the following code from the cpearson website here http://www.cpearson.com/excel/classes.aspx but I'm not sure I'm following exactly. I've created the Class Module named CEmployee with the following code :

Please Login or Register  to view this content.

and in a new module I'm testing it :

Please Login or Register  to view this content.

It all works fine and dandy but I don't see how I can use this in my code. How and where can I use the class blueprint I've created to "remember" multiple instances of the class. I understand the GET the property is telling Name to be a string and the LET is writing over it in the class. Do I need to remove the LET property and make the class read only so that I can use it again ?

Would the following pseudo code work for example, saying that there are strings in A1:A3:

Please Login or Register  to view this content.

Thanks,
amphi

**Norie** · 01-19-2016, 03:07 PM

If you look further down the page you've linked to you'll see code that uses a collection to store multiple instances of CEmployee.

Mind you, creating a further class, say CEmployees, might be another option though that would also use a collection.