How to generate a new form according to items in listbox

[lavender57_1014]

I'm creating a program that generate new form using userform.
So basically there are two list box, the first has all column titles and second is selected column titles. Between those two list boxes are two buttons: add and delete.
The above works fine, but I have one last step to define the button to generate new form.

The idea is that once the user clicks the button, it will generate new forms according to the selected column titles.
My logic is that find the listbox item matches to the form cell, copy the entire column below and paste to the new sheet.

The following are my code, which can't compile..

Please Login or Register  to view this content.

// SelectedC is the 2nd list box name.

Someone help me please!

Thank you very much for your help!

[Bernie Deitrick]

If you want to create a separate sheet for each selected value, try:

Please Login or Register  to view this content.

If you want all the columns on one new sheet, try

Please Login or Register  to view this content.