title: How to add a dynamic label in a VBA userform and assign a specific cell value?
body: <p>In the code below I am adding a label "dLblQty" on the click of save button on the userform. And this button needs to be assigned a value from Cell A27 then A28 and so on in each iteration of button press.
  But this gives a Runtime error  '438': Object doesn't support this property or method.
  Please suggest correct way of doing this.</p>
  
  <p>Below is the snippet:</p>
  
  <pre><code>Dim strCap As String
  
  strCap = Worksheets("Tax Invoice - Intra State").Range("A1").Value
  
  Dim dLblQty As Control
  Set dLblQty = UserForm1.Controls.Add("Forms.Label.1", "dLblQty", True)
  With dLblQty
      .Top = 20
      .Left = 20
      .MultiLine = True
      .Height = 100
      .Caption = strCap
  End With
  </code></pre>