OR and AND conditions in IF statement

[karan_kapoor1 (karan kapoor)]

Hiii,
i want to check if the statement contains “agreed”, “approved”, “go ahead” or “disagree”
how can i write the condition in the IF statement?

[Anthony_Humphries]

If MyText is your string variable, use MyText.Contains("agreed") OrElse MyText.Contains("approved") OrElse MyText.Contains("go ahead") OrElse MyText.Contains("disagree").

If you need to process each of these separately, I recommend taking each condition and putting them in separate If statements to handle each differently.

[Yoichi]

Hi,

Hope the following helps you.

If number of your condition change, please add keyword to array (arrConditions).

Regards,

[Anthony_Humphries]

Very clean solution @Yoichi. I tend to forget/not think of where it would be wise to implement functions.