Vba collection contains

' Vba collection contains
Public Function ExistsInCollection(col As Collection, pKey As Variant) As Boolean
    On Error GoTo err
    ExistsInCollection = True
    IsObject (col.Item(pKey))
    Exit Function
err:
    ExistsInCollection = False
End Function

Similar codes

8 votes219 views1 answer
Excel vba determine number of elements in a 2D array
VBA
1 vote138 views1 answer
Excel vba compare 2 rows
VBA
0 vote145 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote149 views1 answer
Create links in msgbox in vb
VBA
6 votes141 views1 answer
Excel vba check if a string only contains alpha characters
VBA
4 votes151 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
1 vote149 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote127 views1 answer
Docker vboxmanage not found
VBA
4 votes151 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
1 vote150 views1 answer
Excel vba last row of range
VBA