title: Using a counter in VBA
body: <p>I'm working making a loop to get data out of a combo form.</p>
  
  <p><code>Analysis_</code>1 is the first variable 
  <code>Analysis_1_ComboB</code> is the first <code>ComboBox</code> from the screen</p>
  
  <pre><code>Analysis_1 = Me.Analysis_1_ComboB.Column(0)
  Analysis_2 = Me.Analysis_2_ComboB.Column(0)
  Analysis_3 = Me.Analysis_3_ComboB.Column(0)
  </code></pre>
  
  <p>etc etc</p>
  
  <p>as single lines, it is working I do want to work with a loop</p>
  
  <pre><code>for counter = 1 to 9
      Analysis_&amp;Counter = Me.Analysis_&amp;Counter&amp;_ComboB.Column(0)
  next counter
  </code></pre>
  
  <p>unfortunately, this is not working, who can help me out here?</p>