How to implement a predicate?

[MarkJohnstoneGitHub]

How to implement Array.FindAll(T[], Predicate)

Aim: To implement a VBA predicate function probably using the VBA AddressOf the VBA predicate function so in C# can obtain its MethodInfo to help build dynamically build a predicate. Would also require the array type info required from VBA?

Research:
how-to-hook-up-a-delegate-using-reflection

HookUpDelegate

Delegation.bas

Public Function FindAll(ByRef Arr As Variant, ByVal AddressOfPredicate As Long) As Variant

CorArray.FindAll

Workaround To Emulate AddressOf Operator In A Class Module](https://stackoverflow.com/a/56704455/10759363)

How do I access a class module in Excel VBA from C#?

Delegate.CreateDelegate Method

How to get .net managed method pointer by "MethodName" that can be called on native code

C# GetDelegateForFunctionPointer with generic delegate

[MarkJohnstoneGitHub]

Implemented a predicate for .Net Arrays by the following:

• Predicate.cs
• IPredicate.cs
• PredicateSingleton.cs
• IPredicateSingleton.cs

Used by the following classes to implement so far:

• Array.Find(T[], Predicate) Method

• Array.FindAll(T[], Predicate) Method

• Array.FindIndex Method

• Array.cs

• ArraySingleton.cs

• IArraySingleton.cs

VBA useage examples

ArrayFindAllPersonExample
PersonFilter Predicate
Person