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.