title: Is it possible to declare a public variable in vba and assign a default value?
body: <p>I want to do this but it won't compile:</p>
  
  <pre><code>Public MyVariable as Integer = 123
  </code></pre>
  
  <p>What's the best way of achieving this?</p>