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
Comments