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