title: How to dynamically update labels captions in VBA form?
body: <p>I want to dynamically set the caption for an array of labels (within a VBA form) based on values stored in a worksheet. Thus far I can set them one-by-one like this:</p>
  
  <pre><code>Label1.Caption = MySheet.Range("A1").Value
  Label2.Caption = MySheet.Range("B1").Value
  Label3.Caption = MySheet.Range("C1").Value ...
  </code></pre>
  
  <p>Having lots of labels that follow a recurrent pattern, I want to use something smarter, like:</p>
  
  <pre><code>'Method1
  For i = 1 To X
      Dim MyLabel as Object: Set MyLabel = "Label" &amp; i
      MyLabel.Caption = MySheet.Cells(i + 1, i).Value
  Next i
  'Method2
  For i = 1 To X
      Label(i).Caption = MySheet.Cells(i + 1, i).Value
  Next I
  'Both Methods failed. I really appreciate some feedback on this.
  </code></pre>