Copy userform
 

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?
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.

Copy userform
 

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.

"Dale Fye" wrote:

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?
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.

Copy userform
 

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

"Joel" wrote in message
...
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.

"Dale Fye" wrote:

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?
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.

Copy userform
 

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).

Dale Fye wrote:

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?
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.

--

Dave Peterson