title: Public vs Private/Dim in Excel VBA
body: <p>I could use some help in understanding using Public vs Dim in a module in Excel 2013 VBA.</p>
  
  <p>First I want to say I did find this great post with excellent definitions (see link below), but no examples and I could use some examples of how I could apply the Public Variables to my project.  Also I am a little confused on when I would need to use the Option Private Module; would I need to use that on each module I have or just the module that holds the below code?</p>
  
  <p><a href="https://stackoverflow.com/questions/3815547/what-is-the-difference-between-dim-global-public-and-private-as-modular-field">stackoverflow descriptions difference between Public/Private</a></p>
  
  <p>What I would like to do is set this up in a Standard Mod so I dont have to continue setting variables for worksheets through all of my UserForms that use the same naming convention for Worksheets they reference.  </p>
  
  <pre><code>Sub PubVar()
  Public wb As Workbook
  Public wsSI As Worksheet
  Public wsRR As Worksheet
  Public wsCalcs As Worksheet
  Public wsNarr As Worksheet
  Public wsEval As Worksheet
  Public wsUW As Worksheet
  Public wsLVBA As Worksheet
  
  Set wb = Application.ThisWorkbook
  Set wsSI = wb.Sheets("SavedInfo")
  Set wsCalcs = wb.Sheets("Calcs")
  Set wsNarr = wb.Sheets("Narrative")
  Set wsEval = wb.Sheets("EvalCL")
  Set wsUW = wb.Sheets("UWCL")
  Set wsLVBA = wb.Sheets("ListsForVBA")
  End Sub
  </code></pre>
  
  <p>Thank you for your assistance.</p>