/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

2 votes302 views1 answer
Excel vba pause
VBA
0 vote339 views1 answer
Refresh token em vb net
VBA
0 vote350 views1 answer
Vba check if class implements interface
VBA
1 vote355 views1 answer
Add rows to datagridview vb.net
VBA
0 vote381 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote384 views1 answer
Vba string
VBA
0 vote353 views1 answer
Ribbon show/hide
VBA
0 vote364 views1 answer
Vba sheet hide unhide
VBA
1 vote352 views1 answer
Excel format cell as kilowatts
VBA
1 vote335 views1 answer
Vba declare api 64 bit 32 bit
VBA