#### If and Select Statements

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...

Else

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.