#end select

Excel VBA : Post 7 : Conditional Processing (SELECT CASE-END SELECT)

Up till now we had IT-THEN-ELSE statement if we were to perform conditional programming. We can use it to check for multiple conditions at once, and then perform an action based upon a selected condition. This is a viable option, however we have better statements to perform the task above.

When we have multiple options or selection programs, the best way to counter them is to use a SELECT CASE.…