title: How to add a list of specific worksheets to the list in ComboBox VBA
body: <p>I found a way to add all of the worksheets in the workbook into the list of the ComboBox on the UserForm, which is done with use of the following code</p>
  
  <pre><code>Private Sub UserForm_Initialize()
      Dim ws As Worksheet
      For Each ws In Worksheets
          cmbSheet.AddItem ws.Name
      Next ws
  End Sub
  </code></pre>
  
  <p>My problem is that I only need to add some specific worksheets and not all of them. For example my user will select specific sheet and by clicking "Continue" button should end up on the selected worksheet to continue his/her task. My workbook holds several worksheets, some of which are used to output data (Reports) and some worksheets contain so called templates, which I want my user (only those) to be able to select from the ComboBox I have talked above.</p>
  
  <p>Can you guys help me please?</p>