Solved Exercises for if elseif else ...

[The_Doc_Man]

True enough, David, but I just didn't want to obscure the fact that it didn't change the overall concept of the CASE construct. AND you do have to be careful about the implied data types. By using a Boolean value (TRUE) you require/force the discriminator expressions to produce Boolean values as well.

 

[cheekybuddha]

True enough, David, but I just didn't want to obscure the fact that it didn't change the overall concept of the CASE construct. AND you do have to be careful about the implied data types. By using a Boolean value (TRUE) you require/force the discriminator expressions to produce Boolean values as well.

Yes, I meant to say the same principle about expressions applies equally to If ... ElseIf ... End If too.

Re. the datatypes: we have seen an example of exactly that earlier in this thread where the Null had to be handled to compare with a string boolean.

 

[Rickdm]

Understanding code will be so much easier for you if you properly indent it so you can see which parts are subordinate to other parts.

Amen