VBA - 嵌套 If 语句



另一个 If 或 ElseIf 语句中的 If 或 ElseIf 语句。内部 If 语句根据最外部的 If 语句执行。这使 VBScript 能够轻松处理复杂条件。

语法

以下是 VBScript 中嵌套 **If** 语句的语法。

If(boolean_expression) Then
   Statement 1
   .....
   .....
   Statement n
   
   If(boolean_expression) Then
      Statement 1
      .....
      .....
      Statement n
   ElseIf (boolean_expression) Then
      Statement 1
      .....
      ....
      Statement n
   Else
      Statement 1
      .....
      ....
      Statement n
   End If
Else
   Statement 1
	.....
	....
   Statement n
End If

示例

为了演示目的,让我们借助函数查找一个正数的类型。

Private Sub nested_if_demo_Click()
   Dim a As Integer
   a = 23
  
   If a > 0 Then
      MsgBox "The Number is a POSITIVE Number"
      
      If a = 1 Then
         MsgBox "The Number is Neither Prime NOR Composite"
      ElseIf a = 2 Then
         MsgBox "The Number is the Only Even Prime Number"
      ElseIf a = 3 Then
         MsgBox "The Number is the Least Odd Prime Number"
      Else
         MsgBox "The Number is NOT 0,1,2 or 3"
      End If
   ElseIf a < 0 Then
      MsgBox "The Number is a NEGATIVE Number"
   Else
      MsgBox "The Number is ZERO"
   End If
End Sub

执行以上代码后,它会生成以下结果。

The Number is a POSITIVE Number
The Number is NOT 0,1,2 or 3
vba_decisions.htm
广告