Greetings,
I'm new to VBA and found out how to create user-defined objects. Now I'm trying to create a properties collection for my new class. I've got all my properties (Get/Let) defined within my class module, but I'm not sure how to create the properties property (?) for this class!? Actually, I'm not sure if my question is correctly asked?! What I'm trying to accomplish is using the following syntax when manipulating an instance of the class:
cl.Properties(intX)
- OR -
for each prp in cl
... some code
next prp
Again, I'm fairly new to classes/objects; I appreciate any/all comments suggestions to my question. Thank you in advance.
Lawrence
I'm new to VBA and found out how to create user-defined objects. Now I'm trying to create a properties collection for my new class. I've got all my properties (Get/Let) defined within my class module, but I'm not sure how to create the properties property (?) for this class!? Actually, I'm not sure if my question is correctly asked?! What I'm trying to accomplish is using the following syntax when manipulating an instance of the class:
cl.Properties(intX)
- OR -
for each prp in cl
... some code
next prp
Again, I'm fairly new to classes/objects; I appreciate any/all comments suggestions to my question. Thank you in advance.
Lawrence