Can't figure it out.. Duplicating a userform

[MFish]

Hi there,

I'm sure there is a way of duplicating a userform. How do you do this? I just need to make three userforms, all EXACTLY alike. I don't want to take the time to measure it all out and place the buttons all the same.

Thanks.

 

[shg]

Set myForm1 = New UserForm1
Set myForm2 = New UserForm1
Set myForm3 = New UserForm1

 

[My Aswer Is This]

Do this:
Open a New Workbook
So now you have the Workbook with your original UserForm Open and a New empty Workbook Open

In the Vba Project Window select your original UserForm and drag it into your New Workbook

Now Give the New Userform a New Name
And Drag it back into The original workbook

Now rename the Userform in your Empty workbook and now drag it into your Original Workbook

Now you have three Userforms in your original workbook with three different names

Then you can just close the new Workbook and do not save changes.

You cannot have three Userforms in the same workbook with the same name

 

[Steve_]

Design one form. Export it. Then import it with a new name. Enjoy.

 

[shg]

Why would you want three copies of the same userform rather than instancing a single form?

 

[My Aswer Is This]

From my understanding exporting a UserForm requires creating a new Workbook

Dragging the Userform into A empty Workbook and then renaming it and then dragging it back into the Original workbook would not require creating a new Workbook.

The workbook you drag them into would not need to be saved

 

[Steve_]

You rename the form in the currently opened workbook. then import your form.

you will have to rename them either way.

 

[MARK858]

From my understanding exporting a UserForm requires creating a new Workbook

No you can export it to another file location (say your desktop) and then import it from there but you would need to rename the original userform.

 

[My Aswer Is This]

I like the dragging technique.
I do it all the time when I drag Marcro module into my Personal Workbook
I write macros in my Normal workbook test them out and then drag them into my Personal Workbook
It takes 5 seconds

I do the same with Userforms

This way the Macro can be used in any Workbook

 

[MFish]

Thank you all.

As for your question, why 3 of the same userforms? I am building a database for a trucking company, that I work for. Each new, but similar, userform will ask the same questions based on the three different comboboxes from the userform prior. But, I need them to be unique so my textboxes from the original userform can copy the same value from the userform that was just shown. Unless there's an easier way, I don't know. I usually get by with what I do but I'm sure the codes I write are miles long, when they don't need to be.