Mismatch error

When I click on the 'Validate' button, the code should look at the value in column A (the "ReturnValue" as String) and compare it to the list of valid values in Myarr (values of the Variant type). If a match is found, all is good and the code moves on to the next cell in column A (Next i). If a match is NOT found, I want to change the font color of the value in column A.

When I look at Myarr in the Watch Window I can see the values are set to Variant/String.

So why am I getting a mismatch error? How do I fix this?

My worksbook is also attached.

Please Login or Register  to view this content.

You cannot compare a value against an array like that, one option would be to use

Please Login or Register  to view this content.

Although if you have a lot of values to compare you'd bet better off using a dictionary.

With a dictionary

Please Login or Register  to view this content.