The syntax for declaring variables outside a Type...End Type statement block is different from the syntax for declaring the elements of the user-defined type. This error has the following causes and solutions:
When declaring a variable with an As clause outside a Type...End Type block, use one of the declaration statements, Dim, ReDim, Static, Public, or Private. For example, the first declaration of MyVar
in the following code generates this error; the second and third declarations of MyVar
are valid:
MyVar As Double ' Invalid declaration syntax.
Dim MyVar As Double
Type AType
MyVar As Double ' This is valid declaration syntax
End Type ' because it's inside a Type block.
Check for an unmatched End Type, and either precede its block with a Type statement, or delete the End Type statement if it isn't needed.
For additional information, select the item in question and press F1.