Sub ppp()
Dim b As Integer
End Sub
у меня VBA не ругнулся)) )
приведите плииз весь текст проги)) )
а система помощи VBA выдала, отдайте на растерзание гугл-транслейту:
Statement invalid outside Type block
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:
You tried to declare a variable outside a Type...End Type block or outside a statement.
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.
You used an End Type statement without a corresponding Type statement.
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.