title: How to get a label caption to be set in VBA?
body: <p>This is my first time with creating a UserForm.
  I've looked for solutions, but as yet have not found one that works.</p>
  
  <p>I am trying to set the caption for a couple of labels. I want them set when the form opens.</p>
  
  <p>I have this right now(In the UserForms code:</p>
  
  <pre><code>Private Sub Budget_Initialize()
      Me.Label25.Caption = Format(Month(Now), "mmmm")
      Me.Label26.Caption = Format(Month(Now) + 1, "mmmm")
      Me.Caption = "Test, Test, Test!"
      Me.Repaint
  End Sub
  </code></pre>
  
  <p>But it doesn't work.</p>
  
  <p>I tried this too(In the ThisWorkbook code):</p>
  
  <pre><code>Private Sub Workbook_Open()
      Budget.Show
      With Budget
          .Label25.Caption = Format(Month(Now), "mmmm")
          .Label26.Caption = Format(Month(Now) + 1, "mmmm")
          .Caption = "Test, Test, Test!"
      End With
      Budget.Repaint
  End Sub
  </code></pre>
  
  <p>It opens the UserForm when I open the workbook, but it doesn't update the captions.</p>
  
  <p>I want the captions to be the names of this month and next month. </p>
  
  <p>What am I doing wrong?</p>