VBA - Filter a class array based on class function

[saboh12617]

Hello,

I was wondering if there was a way to filter a List (Array/Table/Collection… whatever, i can adapt this) of Custom class instances based on a function of this class.

For example, if i Had my class (Person.cls) like this

Private name As String

Public function IsNamed(filter As String) As Boolean
IsNamed = (filter = name)
End Function

How could i filter an array of Person based on the function IsNamed ?
The idea of course is that it would implement nicely into the code, without have to write a loop of reading and testing each value.

Something like

filteredList = initialList.FilterBy(IsNamed("brian"))

I remember this was very easy in Python for example with filter/lambda combos.
I came upon this website but i have a hard time figuring out why/how putting the array-related code in the class works.
Custom Collection Class – Daily Dose of Excel

 

[RoryA]

You're going to need a loop somewhere to access the property/method of each class instance.