If Statement

Syntax:

If condexpr 
 Then [instruction] 
 [Else instruction]

-or-

If condexpr 
 Then

  statements

[ElseIf condexpr 
 Then

  statements]...

[Else

  statements]

End If

-or-

If TypeOf objexprIsobjtype 
 Then ...

Group:Flow Control

Description:
Form 1: Single line if statement. Execute the instruction following the Then if condexpr is True. Otherwise, execute the instruction following the Else. The Else portion is optional.

Form 2: The multiple line if is useful for complex ifs. Each if condexpr is checked in turn. The first True one causes the following statements to be executed. If all are False then the Else's statements are executed. The ElseIf and Else portions are optional.

Form 3: If objexpr's type is the same type or a type descended from objtype the Then portion is executed.

See Also:Select Case, Choose( ), IIf( ).

Example:

---

Sub Main
  S = InputBox("Enter hello, goodbye, dinner or sleep:")
  S = UCase(S)
  If S = "HELLO" Then Debug.Print "come in"
  If S = "GOODBYE" Then Debug.Print "see you later"
  If S = "DINNER" Then
  Debug.Print "Please come in."
  Debug.Print "Dinner will be ready soon."
  ElseIf S = "SLEEP" Then
  Debug.Print "Sorry."
  Debug.Print "We are full for the night"
  End If
EndSub