title: VBA, inline array
body: <p>Looking to create an inline array in Visual Basic for Applications</p>
  
  <p>Something like this would be cool:</p>
  
  <pre><code>Dim a() as Integer
  set a = {1,2,3} 
  </code></pre>
  
  <p>In Java, this would be the equivalent functionality:</p>
  
  <pre><code>int a[] = {1,2,3};
  </code></pre>
  
  <p>Also, bonus points if you can tell me how to find its length afterwards (without needing to hard code it, as all the examples my Googling have uncovered)</p>
  
  <p>(please don't tell me to Google it. I normally don't use vb, and I'm discovering that every result for a vb question on Google is answered terribly. ex, hard coding values)</p>