title: VBA: Arrays and Global Variable Declarations
body: <p>I need to declare an array in VBA that will be used by every function. However, I cannot declare it as a global as I would do in C++.</p>
  
  <p>My code is as follows:</p>
  
  <pre><code>Option Explicit
   Dim test(0 to 10) as String
  
   test(0) = "avds"
   test(1) = "fdsafs"
   ....
  </code></pre>
  
  <p>The following conceptualizes what I am trying to do. </p>
  
  <pre><code> public function store() as boolean
    Worksheets("test").cells(1,1) = test(0)
   End Function
  </code></pre>
  
  <p>How can I achieve this functionality?</p>