title: EXCEL VBA: Userform Code, Repetitive Code Improvement
body: <p>Is there a more efficient way for me to write this userform code?</p>
  
  <pre><code>Private Sub Userform_Initialize()
  
  'do stuff
  
      With Item1_DropDown
          .AddItem "Monday"
          .AddItem "Tuesday"
          .AddItem "Wednesday"
      End With
  
      With Item2_DropDown
          .AddItem "Monday"
          .AddItem "Tuesday"
          .AddItem "Wednesday"
      End With
  
      With Item3_DropDown
          .AddItem "Monday"
          .AddItem "Tuesday"
          .AddItem "Wednesday"
      End With
  
  'and so on, and so on. (I have about fifty of these 'With/End With' blocks)
  
  End Sub
  </code></pre>
  
  <p>Basically, I would like to be able to stop writing so many of these 'With/End With' blocks. Right now, I have this type of code in four of my similarly-constructed userforms. It takes up so much textspace, and it seems like a waste. Is there a better way to do this?</p>
  
  <p>Please know that I've never written a class module. So, if the solution requires it I will need to be babied into it. </p>
  
  <p>Thanks,</p>
  
  <p>Elias</p>