Syntax

It can be used in either a single line syntax or a multiple line "Block" syntax:

Syntax 1:
If condition1 Then statement

---Or---

Syntax 2:
If condition1 Then
   statement
End If

The following code is an example:

If AnyDate < Now Then AnyDate = Now

---Or---

If AnyDate < Now Then
   AnyDate = Now
   Msgbox "Today is " & AnyDate
End If

Note that if you use the single line syntax you do not need the End If statement. If you want to execute more than one line of code when the condition is True, you must use the multiple line block syntax.

You can use the If...Then...Else syntax to define a block of statements, one of which will always be run. It uses the following syntax:

If condition1 Then
   statement
Else
   statement
End If

You can use the ElseIf statement to test several conditions. This replaces the need for several If...Then statements, making your code shorter and easier to read. It uses the following syntax:

If condition1 Then
   statement
ElseIf condition2 Then
   statement
Else
   statement
End If