/VBA/Excel vba check if key is in collection

Excel vba check if key is in collection

'A Dictionary is a better choice when you need to determine if a key 
'is already in the collection. But here is a VBA function that
'reports True or False for Collections:

Function KeyExists(key$, c As Collection)
  On Error Resume Next
  c.Item key
  KeyExists = Err = 0: Err.Clear
End Function

'--------------------------------------------------------------------

MsgBox KeyExists("Netflix", colFANG)

Source: academy.excelhero.com

Similar codes

1 vote198 views1 answer
Set font for ms chart vb.net
VBA
0 vote184 views1 answer
Excel R1C1 mode
VBA
0 vote189 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote177 views1 answer
Dynamically change drop down list visual basic
VBA
1 vote195 views1 answer
Vba login website
VBA
1 vote180 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote178 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote192 views1 answer
Create links in msgbox in vb
VBA
9 votes242 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote184 views1 answer
Visual stuiod not recognising desgined labels
VBA