Add Procedure dialog box

Inserts a new Sub, Function, or Property procedure. The Add Procedure dialog box also allows you to set the scope to public or private, and make all local variables in the procedure static.

The following table describes the dialog box options.

Option	Description
Name	Lists a name for the new procedure.
Type	Identifies the type of procedure to create: - Sub: Creates a new Sub procedure. - Function: Creates a new Function procedure. - Property: Creates a new Let property and Get property procedure pair.
Scope	Sets the procedure's scope to either Public or Private.
All Local variables as Statics	Adds the Static keyword to the procedure definition.
OK	Inserts the procedure template in the Code window.
Cancel	Closes the dialog box without inserting a new procedure.

See also

• Dialog boxes

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.