>Hi Jeff,
>
>>You may want to take a look at Select Case
>
>Thanks, I also found the handy ElseIf clause to the If statement. Any advantages-disadvantages you can think of?

The biggest advantage to the "Select Case" syntax is that the condition is evaluated only once and then compare multiple times.

Another advantage is that I find the "Select Case" statement clearer to read/debug.

But, once that said, I use if/elseif statement every day. If we don't compare the same value, we must use the if statement.