Copy UserForm
 

Is it possible to create a new user form by copying an existing form?

Copy UserForm
 

I start a new workbook.

I copy an existing userform to that new workbook's project. Then copy back to
the original workbook's project.

Then I close that newly created workbook.

Trader wrote:

Is it possible to create a new user form by copying an existing form?

--

Dave Peterson

Copy UserForm
 

Open a new workbook.

Go to the project explorer in the VBE.

select your userform in the project explorer. Hold down the control key
while you drag it to the new workbook. In the project explorer, select the
copy - get its properties visible in the properties window. Change the
name. Now drag it back to your original workbook. Close the dummy
workbook without saving.

--
Regards,
Tom Ogilvy


"Trader" wrote in message
...
Is it possible to create a new user form by copying an existing form?

Copy UserForm
 

Thanks for the help!

"Dave Peterson" wrote:

I start a new workbook.

I copy an existing userform to that new workbook's project. Then copy back to
the original workbook's project.

Then I close that newly created workbook.

Trader wrote:

Is it possible to create a new user form by copying an existing form?

--

Dave Peterson

Copy UserForm
 

Thanks for the help. This will save me a lot of work!

"Tom Ogilvy" wrote:

Open a new workbook.

Go to the project explorer in the VBE.

select your userform in the project explorer. Hold down the control key
while you drag it to the new workbook. In the project explorer, select the
copy - get its properties visible in the properties window. Change the
name. Now drag it back to your original workbook. Close the dummy
workbook without saving.

--
Regards,
Tom Ogilvy


"Trader" wrote in message
...
Is it possible to create a new user form by copying an existing form?