Apr 26, 2016
Excel VBA : Post 7 : Conditional Processing (SELECT CASE-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.…
View On WordPress