The VBA Select Case Statement is an important construct in the VBA language. The Select Case statement in VBA allows the program to execute one set of statements out of many based on what a given expressions evaluates to. In today's post we will look at some basic and intermediate ways in which it can be used when writing VBA code.
Basic Form of the VBA Select Case Statement
[cc lang="vb"]
Select Case expression_to_test
Case expression_value_1 : Code to ...