This documentation is archived and is not being maintained.

Add Procedure Dialog Box

Office 2007

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.

Dialog Box Options


Lists a name for the new procedure.


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.


Sets the procedure's scope to either Public or Private.

All Local Variables as Statics

Adds the Static keyword to the procedure definition.


Inserts the procedure template in the Code window.


Closes the dialog box without inserting a new procedure.