Invalid inside procedure
The statement can't occur in a Sub or Function procedure. This error has the following cause and solution:
One of the following statements appears in a procedure: Declare, Deftype, Private, Public, Option Base, Option Compare, Option Explicit, Option Private, Enum and Type.
Remove the statement from the procedure. The statements can be placed at module level.
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.