title: How do I declare a public variable in a Module and access the variable in my worksheet objects?
body: <p>I'm having trouble declaring a public variable and getting my worksheet objects to access it. For example, I have a collection of strings that won't change (does this mean they're static?), defined in a module:</p>
  
  <pre><code>Dim List1 As New Collection
  
  Public Sub Definitions()
     With List1
     .Add "Steelers"
     .Add "Vikings"
     .Add "Packers"
     End With
  End Sub()
  </code></pre>
  
  <p>Afterward, I would like to call List1 in a private sub from a worksheet:</p>
  
  <pre><code>Private Sub CallThis()
  Call Definitions
  Dim Count as Variant
  For Each Count In List1
     ...
  Next Count
  End Sub
  </code></pre>
  
  <p>However, I get a "Variable not defined" error. What am I doing wrong?</p>
  
  <p>Any help is appreciated! Thanks.</p>