/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 vote167 views1 answer
Vba reverse string
VBA
2 votes162 views1 answer
Vba array contains
VBA
0 vote182 views1 answer
Create links in msgbox in vb
VBA
0 vote187 views1 answer
Prive sub enter clicked vb
VBA
0 vote188 views1 answer
Vba min
VBA
1 vote215 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
3 votes224 views2 answers
Excel "vba" match last value
VBA
1 vote179 views1 answer
Add a index column power bi
VBA
0 vote169 views2 answers
Get excel file from email attachment in vba
VBA
5 votes185 views1 answer
Excel vba left word from Long Integer
VBA