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.

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.

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" <(E-Mail Removed)> wrote in message
news:4C39473F-E971-44AE-B02B-(E-Mail Removed)...
> 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.

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