title: How can I dynamically construct a textbox object reference?
body: <p>I asked a similar question <a href="https://stackoverflow.com/questions/2594041/how-can-i-programmatically-construct-the-object-reference">Here</a> and now I need to do the same thing again but this time using VBA in Excel 2010.</p>
  
  <p>Essentially I have numerous text boxes with generic names (i.e. textbox1,textbox2 etc). How can I programically construct the object reference so that I can create a loop?</p>
  
  <p><strong>EDIT:</strong>
  It is a regular textbox on a worksheet. When I start a sub for this worksheet I can reference the textboxes with the following line:</p>
  
  <pre><code>TextBox1.LinkedCell = "B2"
  </code></pre>