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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for