/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

3 votes167 views1 answer
Vba make long from two shorts
VBA
0 vote174 views1 answer
Vba remove the first character of string
VBA
1 vote117 views1 answer
How to open cmd with vbd
VBA
5 votes164 views1 answer
Excel vba high word from Long Integer
VBA
0 vote166 views1 answer
Vba first line of string
VBA
0 vote175 views1 answer
Vba check if class implements interface
VBA
0 vote172 views1 answer
Arq linux
VBA
0 vote165 views1 answer
How to carry text to the next line in a label in vb.net
VBA
5 votes190 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote158 views1 answer
Vbs exec hidden
VBA