/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 vote287 views2 answers
Vba function return array
VBA
1 vote281 views1 answer
Excel vba autofit
VBA
-1 vote336 views1 answer
Vba sendkeys
VBA
0 vote262 views1 answer
Vb.net round to 2 decimal places
VBA
5 votes322 views1 answer
Vba low word from Long Integer
VBA
0 vote302 views1 answer
Find database connection string vb
VBA
0 vote289 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote290 views1 answer
Get current year vb
VBA
0 vote301 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote311 views1 answer
Excel delete ever other vba
VBA