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

3 votes138 views1 answer
Vba double quote
VBA
0 vote71 views1 answer
Excel autofilter vba
VBA
0 vote118 views1 answer
Enter into cells data grid view
VBA
0 vote122 views1 answer
Vbscript for loop
VBA
15 votes248 views2 answers
Xl vba dynamic string array
VBA
0 vote127 views1 answer
Excel vba copy entire sheet paste values
VBA
3 votes135 views1 answer
Vba make long from two words
VBA
0 vote134 views1 answer
Vba clear collection
VBA
0 vote174 views2 answers
Excel vba store array and write to sheet
VBA
0 vote142 views1 answer
Excel vba set cell value to empty
VBA