Add Procedure Dialog Box

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

insproc_ZA01201617

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.

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.

Show: