Changing If Else to Case statement

[iisailor]

The advice of users on this site im trying now to change my If statements to Case statements. Ive been able to handle it with no problems until now. Im trying now to change this:

If Range("B" & StockSearch).Value = Range("A" & OrderRange).Value And _
                Range("C" & StockSearch).Value = Range("B" & OrderRange).Value And _
                Range("D" & StockSearch).Value = Range("C" & OrderRange).Value Then

The problem is i dont know how to use the And_ in a case statement.
Any help greatly appreciated
Chris

 

[Andrew Fergus]

Hi Chris

Often case select statements are used where you have a single variable that can contain many possible values, each of which is then used for a certain path of logic. So instead of having something like:

if x =1 then
...
elseif x=2 then
...
elseif x= 3 then
...
etc.
end if

Instead you have something like:

Select Case x
case 1
...
case 2
...
etc.
End Select

So in conclusion I'm not sure you want to use select case where you are testing multiple variables (per your sample). If however, what we are seeing is part of a much larger network of conditions, then it may be ok to use select case - but we would probably need to see the rest of the code. For instance, there is nothing preventing you from using select case at the highest level, and then nested if statements if you have certain logic paths you want to follow........in summary it depends, but we probably need to see more of what you are trying to do.


Andrew