title: How to set textbox name as variable and allow to alter the name in loop?
body: <p><em>I know that the title is unclear .Hence , i try to explain in detail in the content .</em></p>
  
  <p>There are 15 textbox in the VB interface as picture below .   </p>
  
  <p><a href="https://i.stack.imgur.com/XSMAq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XSMAq.png" alt="textbox snapshot"></a></p>
  
  <p><strong>This is a user interface that allows user to input the data and store in worksheets.</strong> </p>
  
  <p>Suppose the user fill all 15 textbox .Then , first row of textbox will pass and store the data in Excel cells A1,B1,C1,D1 correspondingly .The second row of textbox store the data in Excel  cells A2,B2,C2,D2 ......</p>
  
  <p><strong>Hence, I want to use nested loop to solve the problem .</strong> </p>
  
  <pre><code> for {for { Cells.(i,j)=textbox1.value 
  </code></pre>
  
  <p>The left side of the statement is fine ,as every Excel cells have their own ID (column and row order )  .</p>
  
  <p>However ,for the right hand side ,every <code>TextBox</code> names are assigned by me .I name them as textbox1 ,textbox2 ,textbox3... </p>
  
  <p>To let them fit in the loop, i want to change their textbox name during the loop .For example ,</p>
  
  <pre><code>`textbox+i; i++ ;` ' just my thought 
  </code></pre>
  
  <p><strong>Is it possible to do this in reality ?
  Besides,what if the users fill in  data in half row (3 row with data then submit , 2 row blank) .How VBA continue to fill in the data following the row with data?</strong></p>