位置:首頁 > 高級語言 > VBA教學 > VBA嵌套if語句

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