title: Excel VBA - how to set Public Variables question
body: <p>I understand that pubic variables are able to be used between different modules, I have another question but cant seem to find an answer. When I set the variable, can this be public as well?</p>
  <p>i.e. <code>set 123 = thisworkbook.worksheets(&quot;Sheet1&quot;)</code></p>
  <p>is there anyway to set this once and use it between different modules/subs? I have a few modules that uses the same variables quite often.</p>