/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 vote282 views1 answer
If inputbox cancel vba
VBA
1 vote295 views1 answer
Vba optional
VBA
0 vote422 views1 answer
Amd64 vs arm64 linux
VBA
0 vote298 views1 answer
Return na vba
VBA
0 vote314 views2 answers
Vb.net include quotes in string
VBA
3 votes291 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote305 views1 answer
Excel vba protect worksheet without password
VBA
0 vote298 views1 answer
Get current year vb
VBA
0 vote306 views1 answer
Find database connection string vb
VBA
3 votes309 views2 answers
Vba date to string
VBA