The If...Then block has a single line and multiple line syntax. The condition of an If statement can be a comparison or an expression, but it must evaluate to True or False.
If condition Then Statements... 'single line syntax
If condition Then 'multiple line syntax
statements...
End If
The other variation on the If statement is the If...Then...Else statement. This statement should be used when there are different statement blocks to be executed depending on the condition. There is also the If...Then...ElseIf... variation, these can get quite long and cumbersome, at which time you should consider using the Select statement.
If condition Then
statements...
ElseIf condition Then
statements...
End If
The Select Case statement tests the same variable for many different values. This statement tends to be easier to read, understand and follow and should be used in place of a complicated If...Then...ElseIf statement.
Select Case <variable to test>
Case 1
statements...
Case 2
statements...
Case 3
statements...
Case Else
statements...
End Select
See "Language Reference A - Z" chapter for exact syntax and code examples.