Thanks again Skip,
I tried that already, but since the collection (The Cell in the code) is passed to a function that modifies it, I always get nothing in the MsgBox after removing and adding to it again.
The code should give me a True in the MsgBox but it gives me an empty MsgBox instead...
Thanks Skip
I am storing different data types in the collection. But I also want to modify the contents of the collection later. I know the 3 methods and the clear method but couldn’t use them to modify the contents of the collection.
-H
I am new to VBA .. I am trying to modify Items in a Collection.. but I am having a hard time .
This is an example of what I mean ..
Sub Main()
Dim Cell_Matrix As New Collection
Dim Cell_01 As New Collection
Dim Cell_01_Occupancy As Boolean
Cell_01_Occupancy = False...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.