Determining whether an object is a member of a collection in VBA

vba object ms-access collections
inglesp picture inglesp · Sep 26, 2008 · Viewed 127.7k times · Source

How do I determine whether an object is a member of a collection in VBA?

Specifically, I need to find out whether a table definition is a member of the TableDefs collection.

Answer

Vadim picture Vadim · Jun 14, 2009

Isn't it good enough?

Public Function Contains(col As Collection, key As Variant) As Boolean
Dim obj As Variant
On Error GoTo err
    Contains = True
    obj = col(key)
    Exit Function
err:

    Contains = False
End Function

Related questions

VBA Check if variable is empty

I have an object and within it I wanna check if some properties is set to false, like: If (not objresult.EOF) Then 'Some code End if But somehow, sometimes objresult.EOF is Empty, and how can I check it? …

Read More
Parsing JSON in Excel VBA

I have the same issue as in Excel VBA: Parsed JSON Object Loop but cannot find any solution. My JSON has nested objects so suggested solution like VBJSON and vba-json do not work for me. I also fixed one of …

Read More
Creating Word Application using Excel VBA: Run-time error '429': ActiveX component can't create object

I am trying to save Word docs using Excel VBA, but I get the error "ActiveX component can't create object." When I debug, the error comes from the line: Set wrdApps = CreateObject("Word.Application"). It was working, then it started …

Read More