Variables can also be declared in the declarations section at the top of a module : Variable Declaration « Language Basics « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Language Basics
  3. Variable Declaration

Variables can also be declared in the declarations section at the top of a module

 
     Option Explicit
     Dim Sales

     Sub Scope1()
         Sales = Sales + 1
         MsgBox Sales
     End Sub

     Sub Scope2()
         Sales = Sales + 10
         MsgBox Sales
     End Sub








Related examples in the same category

1.Declaring Variables
2.To declare a variable in VBA use the Dim (short for Dimension) statement.
3.Variable declaration is required with Option Explicit and a module level variable (answer) is declared.
4.Forcing Declaration of Variables: Option Explicit
5.If you're going to declare multiple variables on one line, make sure each variable is specifically declared