/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 vote177 views1 answer
Export datagridview to excel vb.net
VBA
0 vote154 views1 answer
Vba word pdf table to excel
VBA
6 votes167 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote186 views1 answer
Vba search string position
VBA
0 vote161 views1 answer
Vba like with wildcard
VBA
0 vote175 views1 answer
Remove series name from legendvbnet
VBA
0 vote211 views1 answer
Vba ternary
VBA
0 vote169 views1 answer
Loop through lines in text file vb net
VBA
1 vote155 views1 answer
Excel format cell as kilowatts
VBA
7 votes187 views1 answer
Excerl vba array to range
VBA