title: How to add VBA label values?
body: <p>I'm just a beginner in using VBA in MS Excel. I have 1 form and 5 labels. Let's just name it Label1 to Label5. I want to have the sum of values of Label1 to Label4 and display it on Label5. </p>
  
  <pre><code>With UserForm1
  
     Dim str As String
     str = Label5.Caption
     str = WorksheetFunction.Sum(.Label1.Caption, .Label2.Caption, _
           .Label3.Caption, .Label4.Caption)
  End With
  </code></pre>
  
  <p>This is the code that I got but it doesn't work. Please help T_T </p>