Expected 'Then'

You created a If...Then...Else construct, but did not include the Then keyword in the first line. The following demonstrates the correct structure of a If...Then...Else construct.

                      If condition Then statements [Else elsestatements ] 

Or, you can use the block form syntax:

                      If condition Then
   [statements]
[ElseIf condition-n Then
   [elseifstatements]] . . .
[Else
   [elsestatements]]
End If

To correct this error

  • Make sure that the If...Then...Else construct includes all the necessary parts.

See Also

Concepts

Using Conditional Statements

Reference

If...Then...Else Statement

Select Case Statement