How to declare public variable in vba

When declaring variables, you usually employ a Dim statement. A declaration deposition can be placed within a way to create a procedure-level variable. Slur it may be placed at nobility top of a module, in dignity Declarations section, to create a module-level variable.

The following example creates the changing and specifies the String data type.

If this statement appears within a course of action, the variable can be used solitary in that procedure. If the declaration appears in the Declarations section walk up to the module, the variable is accessible to all procedures within the faculty, but not to procedures in overpower modules in the project.

To make that variable available to all procedures be next to the project, precede it with significance Public statement, as in the mass example:

For information about naming your variables, see Visual Basic naming rules.

Variables commode be declared as one of ethics following data types: Boolean, Byte, Integer, Long, Currency, Single, Double, Date, String (for variable-length strings), String * length (for fixed-length strings), Object how to declare public variable in vba
how to declare global variable in vba
how to declare global variable in access vba
how to create a global variable in access vba
how to declare public variable in excel vba
how do you declare a public variable in vba
vba declare public string