iPhone & iPad Cases. Accessories. Video Games.
Select Case Statement. Sub Procedure. What is a VBA Module?
1.2. Компоненты оператора Select Case.
Get step-by-step Textbook Solutions or ask homework questions to get expert answers, plus textbook rentals, writing & citation help, exam prep and more.
Select Case statement is useful when you want to check for multiple conditions in Excel VBA. You can use it as an alternative to the IF Then Else statements.
Select [ Case ] testexpression [ Case expressionlist [. statements ] ] [ Case Else [. elsestatements ] ] End Select.
Select Case a Case 5 действие 1 Case 7 To 9 действие 2 Case Else действие 3 End Select. Код получился немного длиннее, но намного понятнее и читаемый.