By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 799 - Select Case

The select case is part of the Conditional statements.

It can be used instead of the if - elseif

Select Case x
   case is 1
       ' do this
   case is 2
       ' do this
   case is 3 to 20
      ' do this

   case else
       ' do this

End Select