Export (0) Print
Expand All

Enter a Declaration in Code

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Declarations are nonexecutable code statements that name external procedures, constants, or variables and define their attributes (such as data type). You write declarations for form, standard, or class modules. To enter module-level declarations, go to the Declarations section of a module. To enter global declarations, go to the Declarations section of a module and use the Public statement for constants and variables. You can also use the Dim, Static, and Private keywords to make declarations.

You can also enter procedure-level declarations. For whatever code level and technique you use to declare a variable or constant, specific scoping rules may apply.

To open the Declarations section of a module

  1. In the Project window, select the form, standard, or class module you want to open and click the View Code button. – Or – Right-click and choose View Code from the context menu.

  2. Object box

    The Procedure box automatically displays (Declarations).

  3. Enter one or more declarations.

Show:
© 2014 Microsoft