Copy userform

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

Guest

I have a userform I am using for data entry into several Excel spreadsheets.
This particular form uses a tab (multi-page) control to give me the ability
to collect as much info as possible without having to scroll the page down.

I would like to copy this userform so that I can modify it slightly for
print purposes, but have not been able to figure out how to copy it, or
export and import it using another name, or any other method to accomplish
this task.
What am I missing?
 
If it is a VBA userform. then go to VBA project window and open up
userform. Then right click the userform. There is an export option.
 
I did that, but when I tried to import it, it gave me some error message
about there already being a form with that name. Is it as simple as:

1. Export the form
2. renam the form in the current workbook
3. Import the original form

Nah, it cannot be that easy, not after I spent 30 minutes trying to figure
this out. ;-(

Dale
 
You can also open both (all?) workbooks.

Then open the VBE and just drag and drop the userform from one project to
another (in the Project explorer window).
 
Back
Top