Check if TextBox contains item from Array

Hi All,

I'm trying to get a textbox in a VBA userform to throw an alert if it contains anywhere in the whole box, certain words or phrases dictated by an array.

Currently, if the TextBox contains ONLY the array item, it works and I get my box to go red. But if the TextBox contains other text i.e. "this that and the other, Option 1 is best" then the TextBox is not highlighted red.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Just wondering if anyone can help? I've tried using the Instr method to get things done, but I cant seem to wrap my head around the syntax of it all.

Any help is much appreciated!

Cheers

Using the InStr function...

Please Login or Register  to view this content.

Apologies for not attaching the file. I often find trying to disassemble this particular workbook and remove sensitive information takes much longer than it would having just provided the snippet of code I did!

As it happens @dangelor, that amendment in bold did just the trick! Works a charm! Thank you so much for your help! Will mark thread as solved! It always astounds me how quickly members of this forum are able to digest and analyse code and come up with a working solution! Thanks again

Glad I could help!