Procedure type mismatch

You are using one kind of Property procedure where a different kind is expected. This error has the following causes and solutions:

• You are trying to write to a property that is read-only.

  If the only property procedure defined for the property is a Property Get, you can't assign a value to the property. Either write an appropriate Property Let procedure, or don't attempt to write to the property.

• You are trying to read a property that is write-only. If the only property procedure defined for the property is a Property Let, you can't read the value of the property. Either write an appropriate Property Get procedure, or don't attempt to write to the property.

• You are trying to set a reference but the property has only Property Get or Property Let procedures. Either write a Property Set procedure for the property, or don't try to set a reference to it.

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.