Find String in an Excel list using VBA

Dear Excel Expert,

I have a dynamic list in Excel that will contain strings representing codes.

i.e

MEM
YYZO
KAC
PAPKG
QEP
LMNT


The user can add or delete from the list but the list will remain contiguous.


In my vba code I currently have the below line which has the codes hard coded.

If Not (varElement.Broker = "MEM" Or varElement.Broker = "YYZO" Or varElement.Broker = "KAC" Or varElement.Broker = "PAPKG") Then

How do I convert the hard coded NOT (A OR B OR C ...) to use the dynamic list instead?

Thank you