What is the benefit of using Select Case over If-Then in Excel VBA?

Answer 1

When coding in VBA, SELECT CASE and IF THEN provide the same result. However, SELECT CASE is a better choice if you have numerous Cases/Conditions. It is cleaner and easier code to read as indented CASE statements as opposed to a litany of IF-THEN-ELSE IF statements. Alternatively, if you have a very large number of Conditions/Cases, an ARRAY is a better coding choice.