How can I duplicate a user form and all code?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to copy a user form will all of the associated code and only
make slight modifications to it, so I don't want to start from scratch. Is
this possible?
 
Hi Paul,

In the VBE, goto the Explorer pane (Ctrl-R), select the Userform file:

File | Export


The userform can subsequently be imported via the File | Import menu.
 
Paul,

Or... in the VBE, drag the form to another project and drop it.
A copy is automatically created.

Jim Cone
San Francisco, USA


I would like to copy a user form will all of the associated code and only
make slight modifications to it, so I don't want to start from scratch. Is
this possible?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

duplicate a user form? 3
How to use multiple command button to copy user form data to multiple worksheet 0
How do you resize a Multi Page User Form? 16
Remove duplicates from list using code 5
How can I migrate MBOX to PST? 2
User Form Problem 2
How to activate a User Form 1
best way to validate data in forms; 2010 1

Back
Top