Creating Tabs from a ComboBox in a form

[gheyman]

On a tab I have a list of Customers along with their ID. I also have a Template where the user will input information about some of the customers.

Right now the user goes to the user Template and copies it and then in a list on that tab selects the customer and then starts entering data.

I was thinking of having a Form pop up where it shows all the customers and their ID in a list/combo Box. When the user triggers the Userform they can go through the list and make selections of which customers they need to enter data for. From that multi selection they click a button on the form and a copy of the Template is duplicated/copied for each customer selected in the list.

So if the user selects Smith, Jones and Brown out of the list of 100 customers, the code will make 3 copies of the template.

(I will rename each tab as they are made)

My question is; is what I want to do possible? Is there a way to know how many selections where made in the list-box by the user?

 

[Fluff]

You can do it with a multiselect listbox, like

Private Sub CommandButton1_Click()
Dim i As Long
With Me.ListBox1
   For i = 0 To .ListCount - 1
      If .Selected(i) Then
         Sheets("new").Copy , Sheets(Sheets.Count)
         ActiveSheet.Name = .List(i)
      End If
   Next i
End With
End Sub

 

[gheyman]

Thanks!

 

[Fluff]

You're welcome