Top.Mail.Ru
Ответы

Statement invalid outside Type block?? Ошибка в VBA. Ошибка относится к строке: Dim b as Integer

По дате
По Рейтингу
Аватар пользователя
Новичок
12лет

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.