remove an object from a collection using the for each loop approach vs for i = loop

Below are two methods of deleting an object from a collection.
(1) uses a "for i = loop"
(2) the other uses a "for each loop"

I can remove the target object from the target collection using the for i = loop

I do not understand what value should go into the Remove method
for the "for each loop".

The workbook ("Junk Test objects within a collection.xlsm") for the code is attached

Below you will see both code approaches. They can be found in the module, Test_House_Class.

The Test_House_Class module is dependent upon custom classes:
aFloor is an instance of a Floor_Class
FloorCollection is an instance of a Floor_CollectionClass

Please Login or Register  to view this content.

Good Evening 6Stringer !!!!

topic: "I did not find any of this code in your attached file, BTW
* open the attached file
* there appear to be 2 VBA Project (junk test collection within an object)
would love to delete the first one but have no idea what i would be deleting; hence i have left it there
* go to the second version
* go to the modules folder
* go to Test_House_Class
dbl click
go to line 86

* go to class modules
* find House_Class
* find Floor_Class
* Find Floor_CollectionClass

Did that help? i am trying very hard to make your helping me easier. I appreciate all the help i get here in this forum. Thank you!!!!

Thank you Rory !!!!

Despite the valid comments of previous speakers, check the operation of this:

Please Login or Register  to view this content.

But this is the so-called "partisan".
In subsequent tests, reduce the value of 2 in the red line to 1 and then to 0. Passing the code run in step mode (F8), observe in the Watches window the contents of the FloorCollection.

Earlier I prepared another code for you to explain something. Remove my first suggestion and insert:

Please Login or Register  to view this content.

Learn to observe variables and objects in the Watches window and use the step-by-step mode of code execution. This makes it very easy to understand what is happening to variables or objects at any given time.

Artik