<div>
Not a bad idea, did not think of that myself. Regarding performance, I guess that adding a parent will not affect performance much as long as it is passed as a reference. How can I assure that? Is it as simple as adding the ByRef keyword to the set property, e.g.:<br />
<br />

<pre><code id="code-20-38409505-1">Public Property Set Parent(ByRef ParentToSet as SomeObjectCollection)
   Set mParent = ParentToSet 
End Property</code></pre>
</div>


Not a bad idea, did not think of that myself. Regarding performance, I guess that adding a parent will not affect performance much as long as it is passed as a reference. How can I assure that? Is it as simple as adding the ByRef keyword to the set property, e.g.:



Public Property Set Parent(ByRef ParentToSet as SomeObjectCollection)
   Set mParent = ParentToSet 
End Property

<div>
If you pass an object ByVal you only pass a copy of the pointer, not a copy of the object, so I'm not sure how that would affect performance but using ByRef should work.
</div>


If you pass an object ByVal you only pass a copy of the pointer, not a copy of the object, so I'm not sure how that would affect performance but using ByRef should work.

<div>
<div class="content wysiwyg-content">
I have defined an class - lets call it SomeClass - with a range of different events. <br />
In order to create a functionality for storing and handling batches of these classes, I have also created a collection class - lets call it SomeClassCollection. Within this the SomeClass objects are stored in a collection.<br />
<br />
I would really like to be able to catch the events of individual SomeClass objects in the collection. And let the SomeClassCollection object act accordingly (e.g. by raising its own event). Is this in any way possible?
</div>
</div>


I have defined an class - lets call it SomeClass - with a range of different events. 
In order to create a functionality for storing and handling batches of these classes, I have also created a collection class - lets call it SomeClassCollection. Within this the SomeClass objects are stored in a collection.

I would really like to be able to catch the events of individual SomeClass objects in the collection. And let the SomeClassCollection object act accordingly (e.g. by raising its own event). Is this in any way possible?

How to catch events of objects in a collection in VBA?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.