A module is not a valid type

A standard module doesn't represent a class and can't be instantiated in the form of a variable. This error has the following cause and solution:

  • You used the name of a standard module in a Dim or Set declaration. Check the spelling of the module name and make sure it corresponds to a form, MDI form, or class module.

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.