/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

0 vote355 views1 answer
Vba like with wildcard
VBA
12 votes495 views1 answer
Excel vba write string to text file
VBA
0 vote406 views1 answer
Move bindingnavigator vb
VBA
0 vote356 views1 answer
Remove frist letter from string vbnet
VBA
1 vote360 views1 answer
Vba reverse string
VBA
0 vote356 views1 answer
Vbs send keys
VBA
0 vote380 views1 answer
Vba multiple optional arguments
VBA
0 vote339 views1 answer
Do until vb.net
VBA
0 vote369 views1 answer
Delete rows in excel vba code
VBA
0 vote385 views1 answer
Vba min
VBA