Populate Workbook with a Worksheet for each ComboBox List Item

[R_S_6]

Hi All,

I have a userform that utilises a combobox, CB1 to allow the user to select a predefined item, or to input their own item. If the user inputs their own item, it is added to the the list in the combobox. The combobox list is populated by the following code - It references Sheet 3 and the items in column A from Row 2 to Row with the last value.

Please Login or Register  to view this content.

Thus when the user writes in the combobox, it adds another item to column A (using another code in my workbook).

Now what I require.....
For each of the combobox list items, I require a separate worksheet to be created in the workbook. If the worksheet already exists it must remain unaffected; if it doesn't then it needs to be created and named as per the of the combobox list item names.

I'm sure this is very easy but in my slow learning of vba I haven't quite got my head around the looping of events and 'for each' etc.

Any help would be greatly appreciated as always.
Cheers,
Mark

[R_S_6]

Okay a bit more digging around on the net and I have managed to cobble something together. Thought I would post it for the benefit of other :

Please Login or Register  to view this content.

Cheers,
Mark