Argument required for Property Let or Property Set

  • Article

The purpose of Property Let and Property Set procedures is to give a new value to a property. This error has the following causes and solutions:

  • In setting the property, the value doesn't appear in the right place. Place the value to which you want to set the property on the right side of the expression setting the property value.

  • In the procedure definition, the parameter defined to receive the value passed on the right side of the expression is missing or misplaced.

    Specify a parameter for the value argument list in the procedure definition. If the procedure takes more than one argument, the property-value parameter must appear last in the list.

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.