GetSecureScore

How to use Excel VBA “Select Case”

Select Case statement Executes one of several groups of statements, depending on the value of an expression. Syntax Select Case testexpression[ Case expressionlist-n [ statements-n ]][ Case Else [ elsestatements ]]End Select The Select Case statement syntax has these parts: Part Description testexpression Required. Any numeric expression or string expression. expressionlist-n Required if a Case appears. Delimited list of one or more of the following forms: expression, expression to expression, Is comparison operator expression. The To keyword specifies a range of Read More