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.

 

[DanteAmor]

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.

The problem is not creating copies of forms, the next problem is to maintain the three forms, each time you change something, you must replicate it in the other forms. There are always changes in the systems!

 

[My Aswer Is This]

Give us one specific thing you want to happen.

Not mentioning other UserForms

Just say when I click on this button or select this value from ComboBox I want this to happen

Give specifics like I want the value I click on in Combox1 to be entered on sheet named "Master" Range("B1")

 

[MFish]

Ok, so ultimately this is what I need done...

Acronym for referencing
Userform1 = UF1
Userform2 = UF2

UF1 will show after clicking a commandbutton on excel master sheet1. <-- I got this coded correctly

In UF1, will have three comboboxes pulling data from "Drop Down Data" sheet. <-- I got this coded correctly

​

When I select any of the comboboxes data, it will bring up UF2. <--I got this
In UF2 it will have a combobox that I must select another value. <-- similar to above, I got that.

Within UF2, I have a commandbutton that "submits" this data, and closes this UF2 and shows UF1, again. BUT I need the value of combobox in UF2 to show in textbox in UF1.
​

Back in UF1, I will have 1 out of 3 comboboxes with the value I have selected, alongside this will have a textbox that copies the information from the combobox I selected in UF2.
In UF1, I need a commandbutton that will take the value of the combobox and textbox and place that information on Excel Sheet 2, starting with A1 as Combobox data and B1 as Textbox data.

Then on sheet 2 I will need a button that will filter, alphanumerically, column A:A.

 

[My Aswer Is This]

I was just asking what you wanted to achieve as a end result. Not how to do it the way you have described.

I do not believe you need more then one UserForm

You believe for some reason the only way to do what you want is to use two or three UserForms