Expected Function or variable

  • Article

The syntax of your statement indicates a variable or function call. This error has the following cause and solution:

  • The name isn't that of a known variable or Function procedure.

    Check the spelling of the name. Make sure that any variable or function with that name is visible in the portion of the program from which you are referencing it. For example, if a function is defined as Private or a variable isn't defined as Public, it's only visible within its own module.

  • You are trying to inappropriately assign a value to a procedure name.

    For example if MySub is a Sub procedure, the following code generates this error:

    MySub = 237    ' Causes Expected Function or variable error

    Although you can use assignment syntax with a Property Let procedure or with a Function that returns an object or a Variant containing an object, you can't use assignment syntax with a Sub, Property Get, or Property Set procedure.

For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.