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.

If...Then...Else Statement | Select Case Statement |