Tidying a messy compound if statement - is there a better way?

[TC1980]

Hi All,

Quick question for you; I have a compound if statement that I'm using in some code but it's a bit messy and I was wondering if there is a way to tidy it up or a better way of doing it.

The code needs to test if one of two scenarios are met them carry out a task - the same tast for the two scenarios. Both scenarios have multiple criteria with much of it shared between the two but one difference meaning an additional criteria needs to be checked. In this example 'C':

Please Login or Register  to view this content.

Ideally it would be good to have it exit the statement if A<>1 and I have heard you can use AndAlso and OrElse, but I have not come across them before and not sure how to construct a statement with them.

Any alternative ideas appreciated.

Thanks, TC

[romperstomper]

There are different approaches but you can use nested If statements:

Please Login or Register  to view this content.

for example. You may also want to look at Select Case statements if you are not familiar with them.

[patel45]

Please Login or Register  to view this content.

[TC1980]

Hi RomperStomper and Patel45

Thanks for coming back on this. I like the idea of nesting the if's so each criteria is checked in turn and I forgot about brackets so thanks for the reminder.
Am familar with Select Case statements and this If is actually inside a case. Not sure there is any real benefit in susing one in this instance.

Thanks again, TC