title: Link multiple cells to TextBox VBA
body: <p>Hi I am new to VBA but want to do something seemingly simple, however I cannot figure it out.</p>
  
  <p>I would like to link multiple cells to a textbox and have the values be on different lines.
  Ex.
  A1 = Blue; B1 = Red; C1 = Yellow</p>
  
  <p>I want to have a textbox return:
  <br>Red<br>
  Blue<br>
  Yellow<br></p>
  
  <p>I cannot find an answer to this anywhere.</p>
  
  <p>The code I have now is:</p>
  
  <pre><code>Sub Macro2()
  
  ' Macro2 Macro
  
      ActiveSheet.Shapes.Range(Array("TextBox 2")).Select
      Selection.Formula = "=$A$1"
  
  End Sub
  </code></pre>
  
  <p>This returns the value of A1 into the text box, but I also need the value of B1 and C1.</p>
  
  <p>Any help would be appreciated. Thanks</p>
  
  <p>Update:</p>
  
  <p>Elbert Villarreal's answer solved my problem, but I have one last question.</p>
  
  <p>I have multiple rows that I would like to do this for (A2, A3, A4). Is there a way to do a loop for these different rows of data?</p>