USER FORM COPY
 

how to copy /move a userform from w/book to another w/book?
how to copy/move only object from w/book to other w/book?
how to copy/move only code of userform from one w/book to other w/book.
copying/moving will affect userform controls's control properties?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200608/1

USER FORM COPY
 

Hi
Select the Userform and go to File, Export File...
To import the userform to another workbook use File, Import File...This
will bring the form and its code modules. If you don't want the code,
delete it.
The imported form should work OK, assuming any references exist in new
workbook (custom controls etc)

regards
Paul

tkraju via OfficeKB.com wrote:
how to copy /move a userform from w/book to another w/book?
how to copy/move only object from w/book to other w/book?
how to copy/move only code of userform from one w/book to other w/book.
copying/moving will affect userform controls's control properties?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200608/1

USER FORM COPY
 

THANKS for your valued information.

wrote:
Hi
Select the Userform and go to File, Export File...
To import the userform to another workbook use File, Import File...This
will bring the form and its code modules. If you don't want the code,
delete it.
The imported form should work OK, assuming any references exist in new
workbook (custom controls etc)

regards
Paul

how to copy /move a userform from w/book to another w/book?
how to copy/move only object from w/book to other w/book?
[quoted text clipped - 4 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200608/1

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200608/1