Invalid optional parameter type

  • Article

Not all Visual Basic types are permitted for Optional parameters. This error has the following causes and solutions:

  • A parameter is defined with an invalid data type. For example, you can't have an Optional parameter of user-defined type. You may be able to accomplish your goal using an array of Variant type, since the elements of an array of Variant can store data of different types.

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.