Line is not an executable statement ошибка vba

Excel 2010 Developer Reference > Visual Basic for Applications Language Reference > Visual Basic Language Reference

Error Messages

Topics

#Else clause must be preceded by a matching #If

#Else If, #Else, or #End If must be preceded by a matching #If

#ElseIf must be preceded by a matching #If or #ElseIf and followed by an #ElseIf, #Else, or #End If

<Item> is not a valid control type (Error 720)

A compatible ActiveX component must be a Visual Basic executable or a DLL

A form can’t be moved or sized while minimized or maximized

A module is not a valid type

A procedure of that name already exists

A procedure with a ParamArray argument cannot be called with named arguments

A property or method call cannot include a reference to a private object, either as an argument or as a return value (Error 98)

ActiveX component can’t create object or return reference to this object (Error 429)

ActiveX Component did not run correctly (Error 338)

ActiveX component not correctly registered (Error 336)

ActiveX control ‘item’ not found (Error 363)

Add-in can’t reference project

Ambiguous name detected

AppleScript error

Application-defined or object-defined error

Argument not optional (Error 449)

Argument required for Property Let or Property Set

Array already dimensioned

Array argument must be ByRef

Assignment to constant not permitted

Automation error (Error 440)

Automation object doesn’t have a default value (Error 443)

Bad DLL calling convention (Error 49)

Bad file mode (Error 54)

Bad file name or number (Error 52)

Bad interface for Implements: interface contains data fields

Bad interface for Implements: interface is derived from another pure interface with non-restricted methods

Bad interface for Implements: interface is not derived from Iunknown

Bad interface for Implements: method does not return HRESULT

Bad interface for Implements: method has out-only or LCID parameter

Bad interface for Implements: method has parameter with too many levels of indirection

Bad interface for Implements: method has underscore in name

Bad interface for Implements: methods uses type that is not supported by Visual Basic

Bad record length (Error 59)

Bad record number (Error 63)

Beginning of search scope has been reached; do you want to continue from the end?

Block If without End If

Breakpoint not allowed on this line

ByRef argument type mismatch

Calling convention not supported by Visual Basic

Cannot define a KWID_tkPUBLIC user-defined type within a private object module

Cannot display specified name because it is hidden

Cannot handle events for the object specified

Cannot jump to specified type because it is in the specified library, which is not currently referenced

Can’t add a reference to the specified file

Can’t assign or coerce array of fixed-length string or user-defined type to Variant

Can’t assign to an array

Can’t call Friend procedure on an object that isn’t an instance of the defining class (Error 97)

Can’t change data types of array elements

Can’t create AutoRedraw image (Error 480)

Can’t create necessary temporary file (Error 322)

Can’t display hidden procedure

Can’t display system information

Can’t edit module

Can’t empty Clipboard (Error 520)

Can’t enter break mode at this time

Can’t execute code in break mode

Can’t execute immediate statements in design mode

Can’t exit design mode because control can’t be created

Can’t find DLL entry point in specified DLL

Can’t find project or library

Can’t find Windows Help .exe file

Can’t Get or Put user-defined type containing object reference

Can’t have paramarrays with optional arguments

Can’t load module; invalid format

Can’t load or unload this object (Error 361)

Can’t make an assignment to a read-only property

Can’t open Clipboard (Error 521)

Can’t perform operation because the project is protected

Can’t perform requested operation (Error 17)

Can’t perform requested operation since the module is hidden

Can’t place conditional breakpoint on an array

Can’t print form image to this type of printer (Error 486)

Can’t print minimized form image

Can’t quit at this time

Can’t record into running module

Can’t ReDim, Erase, or assign to Variant that contains array whose element is With object

Can’t remove control or reference; in use

Can’t remove default reference

Can’t rename with different drive (Error 74)

Can’t save file to TEMP directory (Error 735)

Can’t set the project name at this time

Can’t show non-modal form when modal form is displayed

Can’t sink this object’s events because it’s already firing events to the maximum number of supported event recipients (Error 96)

Can’t start new recording until current session is ended

Can’t use character device names in file names: ‘item’ (Error 320)

Case Else outside Select Case

Case without Select Case

Circular dependencies between modules

Class doesn’t support Automation (Error 430)

Class is not set (Error 31018)

Class not registered on local machine (Error 463)

Class not registered. ‘item 1’

Code execution has been interrupted

Code resource lock error (Error 455)

Code resource not found (Error 454)

Compile error in hidden module: <module name>

Component not correctly registered

Conflicting attributes were found in ‘item’. The defaults will be used

Conflicting names were found in ‘item1’. The name ‘item2’ will be used

Connection to type library or object library for remote process has been lost (Error 442)

Constant expression required

Constants, fixed-length strings, arrays, user-defined types, and Declare statements not allowed as Public members of an object module

Could not access system registry (Error 335)

Could not create reference: ‘item’

Could not execute specified program

Could not start Internet Explorer

Current module does not support Print method

Cyclic reference of projects not allowed

Data value named not found (Error 327)

Definitions of property procedures for the same property are inconsistent

Deftype statements must precede declarations

Destination label too far away; loop, Select Case, or block If too large

Device I/O error (Error 57)

Device unavailable (Error 68)

Disk full (Error 61)

Disk not ready (Error 71)

Display more load errors?

Division by zero (Error 11)

Do without Loop

Do you want to export specified object before removing it?

Duplicate declaration in current scope

Duplicate definition

Duplicate Deftype statement

Duplicate Option statement

Duplicate procedure name

Duplicate resources with same type and name

Edit can’t be undone—proceed anyway?

Else without If

Empty Enum type not allowed

Empty watch expression

End If without block If

End of search scope has been reached; do you want to continue from the beginning?

End Select without Select Case

End With without With

Enum types defined in standard modules or private classes cannot be used in public object modules as parameters or return types for public procedures, as public data members, or as fields of public user defined types

Error accessing the system registry

Error in loading DLL (Error 48)

Error loading from file (Error 31037)

Error loading ‘item’. A control could not be loaded due to load error. Continue?

Error loading ‘item’. An error was encountered loading a property. Continue?

Error saving to file (Error 31036)

Errors during load. Refer to ‘item’ for details

Errors occurred during load

Event handler is invalid

Event not found

Exit Do not within Do…Loop

Exit For not within For…Next

Exit Function not allowed in Sub or Property

Exit Property not allowed in Function or Sub

Exit Sub not allowed in Function or Property

Expected array

Expected End Function

Expected End Property

Expected End Sub

Expected End With

Expected Function or variable

Expected procedure, not module

Expected procedure, not project or library

Expected procedure, not user-defined type

Expected procedure, not variable

Expected Sub, Function, or Property

Expected user-defined type, not project

Expected variable or procedure, not Enum type

Expected variable or procedure, not module

Expected variable or procedure, not project

Expected: <various>

Expression too complex (Error 16)

External name not defined

Failed to activate control ‘item 1’. This control may be incompatible with your application. Make sure you are using the version of the control that was provided with your application.

Failed to load control ‘item1’ from ‘item2’. Your version of ‘item2’ may be outdated. Make sure you are using the version of the control that was provided with your application.

File already exists (Error 58)

File already open (Error 55)

File format no longer supported

File is read-only

File not found (Error 53)

File specified was not found

Filename or class name not found during Automation operation (Error 432)

Fixed or static data can’t be larger than 64K

Fixed-length strings and use of the ‘new’ qualifier are not allowed for fields in a public user defined type defined in an object module

Fixed-length strings not allowed as the type of a public member of an object module; private object modules not allowed as the type of a public member of a public object module

For control variable already in use

For Each can only iterate over a collection object or an array

For Each control variable must be Variant or Object

For Each control variable on arrays must be Variant

For Each may not be used on array of user-defined type or fixed-length strings

For loop not initialized (Error 92)

For without Next

Form already displayed; can’t show modally (Error 400)

Form not found (Error 424)

Forward reference to user-defined type

Function call on left-hand side of assignment must return Variant or Object

Function marked as restricted or uses a type not supported in Visual Basic

Identifier too long

Identifier under cursor isn’t a procedure name

Illegal parameter. Can’t write arrays (Error 328)

Illegal parameter. Can’t write object because it does not support persistence.

Illegal parameter. Can’t write user-defined type.

Incorrect DLL version

Incorrect OLE version

Input past end of file (Error 62)

Insufficient Immediate window memory to create variable

Insufficient memory to save Undo information

Insufficient project information to load project on platform or with version now being used

Interface not valid for Implements

Internal error (Error 51)

Invalid Access mode

Invalid attribute in Sub, Function, or Property

Invalid character

Invalid Clipboard format (Error 460)

Invalid Clipboard format (Error 460)

Invalid data format

Invalid data type for constant

Invalid event name

Invalid file format (Error 321)

Invalid file format (Error 321)

Invalid format in resource file (Error 325)

Invalid in Immediate window

Invalid inside Enum

Invalid inside procedure

Invalid length for fixed-length string

Invalid Next control variable reference

Invalid object use (Error 425)

Invalid optional parameter type

Invalid or unqualified reference

Invalid ordinal (Error 452)

Invalid outside Enum

Invalid outside procedure

Invalid ParamArray use

Invalid pattern string (Error 93)

Invalid picture (Error 481)

Invalid picture (Error 481)

Invalid picture type (Error 485)

Invalid procedure call or argument (Error 5)

Invalid procedure name

Invalid property name

Invalid property value (Error 380)

Invalid property value (Error 380)

Invalid property-array index (Error 381)

Invalid qualifier

Invalid ReDim

Invalid syntax for conditional compiler constant declarations

Invalid Template

Invalid type-declaration character

Invalid use of AddressOf operator

Invalid use of base class name

Invalid use of Me keyword

Invalid use of New keyword

Invalid use of Null (Error 94)

Invalid use of object

Invalid watch expression

Item’ already exists in project

‘item’ cannot be added because it is referenced but not in use by any items in the project. To correct this, uncheck ‘Remove information about unused ActiveX Controls’ in Project Options.

Item’ could not be loaded

‘Item’ could not be loaded. Remove it from the list of available add-ins?

Item’ could not be registered

‘item’ designers can only be used in DLL projects

‘item’ designers cannot be private

‘item’ designers cannot be public in ActiveX EXE projects

‘item’ designers must be public and cannot be used in Standard EXE projects

‘Item’ has an old file format. When saved, it will be saved in a newer format.

‘item’ has caused an access violation. Remove it from the list of available Add-Ins?

‘Item’ is a binary form and can’t be loaded into Visual Basic

‘Item’ is a read-only file

‘item’ is a single-threaded component and cannot be used in multi-threaded projects. Change the threading model for ‘item’ or contact the component vendor for an updated version.

‘Item’ property can’t be read at run time (Error 393)

‘Item’ property can’t be set at run time (Error 382)

‘Item’ property is read-only (Error 383)

‘Item’ property is write-only (Error 394)

‘Item’ will not be loaded. Name is already in use

‘item1’ is an invalid key. The file ‘item2’ can’t be loaded

‘item1’ is referenced by ‘item2’ project and cannot be updated.

Label not defined

Language/country setting has changed

License information for this component not found. You don’t have an appropriate license to use this functionality in the design environment (Error 429)

Line isn’t an executable statement

Line ‘item1’: All controls must precede menus; can’t load control ‘item2’.

Line ‘item1’: Can’t create embedded object in ‘item2’

Line ‘item1’: Can’t create embedded object in ‘item2’; license not found

Line ‘item1’: Can’t load control ‘item2’; containing control not a valid container.

Line ‘item1’: Can’t load control ‘item2’; license not found

Line ‘item1’: Can’t load control ‘item2’; name already in use.

Line ‘item1’: Can’t set checked property in menu ‘item2’. Parent menu can’t be checked.

Line ‘item1’: Can’t set Shortcut property in menu ‘item2’. Parent menu cannot have a shortcut key.

Line ‘item1’: Class ‘item2’ of control ‘item3’ was not a loaded control class.

Line ‘item1’: Class name too long; truncated to ‘item2’.

Line ‘item1’: Control name too long; truncated to ‘item2’.

Line ‘item1’: Could not create reference: ‘item2’

Line ‘item1’: Did not find an index property, and control ‘item2’ already exists.

Line ‘item1’: ‘item2’ has a quoted string where the property name should be.

Line ‘item1’: Maximum nesting level for controls exceeded with ‘item2’.

Line ‘item1’: Missing or invalid control class in file ‘item2 ‘.

Line ‘item1’: Missing or invalid control name in file ‘item2’.

Line ‘item1’: Parent menu ‘item2’ can’t be loaded as a separator.

Line ‘item1’: Property ‘item2’ in control ‘item3’ had an invalid property index.

Line ‘item1’: Property ‘item2’ in ‘item3’ could not be loaded.

Line ‘item1’: Property ‘item2’ in ‘item3’ could not be set.

Line ‘item1’: Property ‘item2’ in ‘item3’ had an invalid file reference.

Line ‘item1’: Property ‘item2’ in ‘item3’ had an invalid value.

Line ‘item1’: Property ‘item2’ in ‘item3’ must be a quoted string.

Line ‘item1’: Syntax error: property ‘item2’ in ‘item3’ was missing an equal sign (=).

Line ‘item1’: The CLSID ‘item2’ for ‘item3’ is invalid.

Line ‘item1’: The control name ‘item2’ is invalid.

Line ‘item1’: The file ‘item2’ could not be loaded.

Line ‘item1’: The Form or MDIForm name ‘item2’ is already in use; can’t load this form.

Line ‘item1’: The Form or MDIForm name ‘item2’ is not valid; can’t load this form.

Line ‘item1’: The property name ‘item2’ in ‘item3’ is invalid.

Line too long

Loop without Do

LSet allowed only on strings and user-defined types

LSet not allowed

Maximum number of watch expressions added

MDI forms are not allowed in multithreaded projects. Any MDI form will be removed from this project. To keep the MDI form in the project select Cancel and change threading model to Thread Pool with only 1 thread.

Member identifier already exists in object module from which this object module derives

Method not valid without suitable object

Method or data member not found (Error 461)

Missing end bracket

Module not found

Module too large

Must be first statement on the line

Must close or hide topmost modal form first (Error 402)

Must specify which item(s) to print

Name conflicts with existing module, project, or object library

Name ‘item’ conflicts with existing module, project, or object library

Named argument already specified

Named argument not found (Error 448)

Named arguments not allowed

Need property-array index (Error 385)

Next without For

No creatable public component detected. Press F1 for more information.

No Help available

No object (Error 31004)

No text selected

No watch expression selected

Not a legal object name: ‘item

Not enough memory to completely save project

Not enough memory to load file

Not enough memory to run; quitting

Object already loaded (Error 360)

Object does not have a Property Let procedure

Object does not source Automation events

Object doesn’t support current locale setting (Error 447)

Object doesn’t support named arguments (Error 446)

Object doesn’t support this action (Error 445)

Object doesn’t support this property or method (Error 438)

Object library feature not supported

Object library for Visual Basic for Applications not found

Object library invalid or contains references to object definitions that could not be found

Object library not registered

Object library’s language setting incompatible with current project

Object module must implement all procedures in interface

Object required (Error 424)

Object server not found (Error 337)

Object variable not set (Error 91)

Object was unloaded (Error 364)

One or more files in the project have changed. Do you want to save the changes now?

One or more instances of this object are running. Can’t remove it at this time.

One or more of the properties in ‘item’ was bad. Some or all of the properties might not be set correctly.

Only comments may appear after End Sub, End Function, or End Property

Only public user defined types defined in public object modules can be used as parameters or return types for public procedures of class modules or as fields of public user defined types

Only valid in object module

Operation not allowed in DLL

Option Private Module not permitted in object module

Optional argument must be Variant

Other applications are currently accessing an object in your program. Ending the program now could cause errors in those programs. End program at this time?

Out of memory (Error 31001)

Out of memory (Error 7)

Out of memory; some watches might have been deleted

Out of resources

Out of stack space (Error 28)

Out of string space (Error 14)

Overflow (Error 6)

ParamArray must be declared as an array of Variant

Path not found (Error 76)

Path/File access error (Error 75)

Permission denied (Error 70)

Permission to use object denied (Error 419)

Please see the Readme file for more information on this error

Printer driver does not support specified property (Error 483)

Printer error (Error 482)

Printer error (Error 482)

Private Enum and user-defined types cannot be used as parameters or return types for public procedures, public data members, or fields of public user-defined types

Private object modules cannot be used in public object modules as parameters or return types for public procedures, as public data members, or as fields of public user defined types

Problem getting printer information from the system; make sure the printer is set up correctly. (Error 484)

Procedure declaration does not match description of event or procedure having same name

Procedure too large

Procedure type mismatch

Project contains too many procedure, variable, and constant names

Project file is read-only

Project is unviewable.

Project not found

Property Get can’t be executed at run time (Error 393)

Property Get can’t be executed on write-only property (Error 394)

Property let procedure not defined and property get procedure did not return an object (Error 451)

Property not found (Error 422)

Property or method not found (Error 423)

Property Set can’t be executed at run time (Error 382)

Property Set can’t be used with a read-only property (Error 383)

Property Set not permitted (Error 387)

Qualified name disallowed in module scope

Qualifier must be collection

Range has no values

Replacements too long (Error 746)

Requested type library or wizard is not a VBA project

Resume without error (Error 20)

Return without GoSub (Error 3)

RSet allowed only on strings

Run-time error <number>:

Search string must be specified

Search string must be specified

Search string too long or complex

Search text isn’t found

Search text not found (Error 744)

Seek failed: can’t read/write from the disk

Select Case without End Select

Selected watch expression invalid

Set Next Statement can only apply to executable lines within current procedure.

SHARE.EXE required

Specified ActiveX component not correctly registered or not found

Specified DLL function not found (Error 453)

Specified format doesn’t match format of data (Error 461)

Specified library or project already referenced

Statement invalid inside Type block

Statement invalid outside Type block

Statement too complex

Statements or labels invalid between Select Case and first Case

String value too long to process; form load aborted

Sub, Function, or Property not defined (Error 35)

Subscript out of range (Error 9)

Syntax error

System DLL ‘dll’ could not be loaded (Error 298)

System error ‘item’

The .VBP file for this project contains an invalid or corrupt library references ID

The ActiveX Designer’s Type Information does not match what was saved. Unable to Load.

The application description can’t be more than 2000 characters long

The code in this project must be updated for use on 64-bit systems

The current project does not support files of this type

The edit may make the object module incompatible with the previously specified compatible ActiveX component

The file ‘item’ is marked as a version not supported by the current version of Visual Basic and won’t be loaded

The file ‘item’ is out of date. This program requires a later version (Error 368)

The form class contained in the specified file is not supported in Visual Basic for Applications; the file can’t be loaded.

The library containing this symbol is not referenced by the current project, so the symbol is undefined. Would you like to add a reference to the containing library now?

The project file ‘item’ is corrupt and can’t be loaded

The project file ‘item1’ contains invalid ‘item2’ key value

The project file ‘item1’ contains invalid ‘item2’ key value. Valid range is 0 to ‘item3’

The project file ‘item1’ contains invalid key ‘item2’. The project can’t be loaded

The project name is too long. Name has been truncated

The remote server machine does not exist or is unavailable (Error 462)

The selected Add-In has not been confirmed to be ‘Command Line Safe,’ and may require some user intervention (possible UI)

The specified file could not be loaded.

The specified object can’t be used as an owner form for Show() (Error 371)

The specified region has been searched

The specified region has been searched and 1 replacement was made

The specified region has been searched and the replacements were made

This action will reset your project, proceed anyway?

This array is fixed or temporarily locked (Error 10)

This command will stop the debugger.

This component doesn’t raise any events

This component doesn’t support this set of events (Error 459)

This control can only be used with ‘item’ designers

This control cannot be used with ‘item’ designers

This designer cannot be used because it uses features that are not supported in this version of Visual Basic

This document was opened with Macros Disabled

This edit requires a Reset

This feature requires Internet Explorer ‘item’ or greater. You can obtain the latest version from http://www.microsoft.com

This interaction between compiled and design environment components is not supported

This key is already associated with an element of this collection (Error 457)

This project is currently referenced by another project and cannot be closed

This VBA project was created while running VBA in a different application. You may only open it from inside the same application in which it was created.

Too many arguments

Too many dimensions

Too many DLL application clients

Too many files (Error 67)

Too many line continuations

Too many local, nonstatic variables

Too many module-level variables

Translation failed. Please check the trnslate.log file for more information.

Trappable Errors

Type mismatch (Error 13)

Type mismatch: array or user-defined type expected

Type not supported in Visual Basic

Type-declaration character does not match declared data type

Type-declaration character not allowed

Type-declaration character required

Unable to activate object (Error 31027)

Unable to create embedded object (Error 31032)

Unable to read from the disk

Unable to unload within this context (Error 365)

Unable to write Designer cache file ‘item’; will just use regular files on Load

Unable to write to the disk

Unexpected compile error

Unexpected error

Unexpected error; please contact Microsoft Technical Support

Unexpected error; quitting

Unmatched brackets in search string

Unrecognized project language

User interrupt occurred (Error 18)

User-defined type may not be passed ByVal

User-defined type not defined

User-defined type without members not allowed

Valid values are whole numbers from 1 to 32

Valid values are whole numbers from 2 to 60

Variable not defined

Variable not yet created in this context

Variable required. Can’t assign to this expression

Variable uses a type not supported in Visual Basic (Error 458)

Version number missing or invalid; Visual Basic 5.0 assumed

Visual Basic can’t load ‘item’ because it is not in the system registry. Please ensure that all add-ins have been installed correctly.

Warning: custom language settings not portable

Wend without While

While without Wend

Windowless controls can’t have menus.

With object must be user-defined type, Object, or Variant

Wizards can’t reference projects

Wrong number of arguments (Error 450)

Wrong number of dimensions

Wrong version of operating system; requires Windows NT 3.51 (build ‘item1’ or later) or Windows 95 (build ‘item2’ or later)

You must save a project before you can reference it.

You must terminate the #If block with an #End If

Component could not successfully create requested object

Component ‘item’ or one of its dependencies not correctly registered: a file is missing or invalid

Component not found in registered location

Invalid Base Address

Programmatic ID string too long ‘item’. The Programmatic ID must be 39 characters or less.

Project <name> has been modified. Do you wish to save the changes now?

The file ‘item’ was not registerable as an ActiveX Component.

The load behavior for ‘item’ could not be updated because of current registry permissions.

The project file ‘item1’ contains invalid key ‘item2’.

Unable to display Help

Unexpected error occurred in code generator or linker

Version numbers must be in the range 0 to 9999

The binary compatibility DLL or EXE contains a parameter type or return type whose definition cannot be found

The binary compatibility DLL or EXE contains an Implements type whose definition cannot be found