VBA: How to store a reference to an Object type within the Object type

[KingLarryXVII]

So this is a bit of a corner case, but I was setting up an Object, cPerson, and wanted to reference their parent's objects, which are also cPerson type, so I could call (rough example):

Set person = New cPerson
Set mother = New cPerson
Set father = New cPerson
set person.Mother = mother
set person.Father = father

The problem is that when I set the properties "Mother" and "Father" within cPerson, I can't have them as type cPerson (stack overflow because each mother needs parents and so on to infinity)

Question: Are there any ways I can create a reference to the 'mother' and 'father' objects within 'person' but not of the type cPerson?

Let me know if the question isn't clear. Thank you in advance!

 

[KingLarryXVII]

Sorry, I was just demonstrating my code pre-fix. I'll modify it here to be more clear.

 

[Zack Barresse]

Oh, gotcha. Glad you got it working!

 

[starl]

To clarify (for any other readers)
"Set" is used when you're setting up an object variable. Remember - objects are like Workbooks, Sheets, Shapes - the things that can have properties and methods assigned to them.
"Let" is used for normal variables, when you're assigning a value

"Get" is when you are retrieving the variable, one either created from Set or Let

 

[starl]

As for recursive..
yeah, i get it. After all, a child can become a parent..