PDA

View Full Version : Moving Forms



pingwin77
07-29-2009, 01:03 PM
If I build a user form in one work book, can I move it into an existing work book?

nst1107
07-29-2009, 01:08 PM
Sure thing. Just remember to make sure all your references are good.

pingwin77
07-29-2009, 01:10 PM
Cool. So how do I copy it from one to another?

nst1107
07-29-2009, 01:26 PM
With both books open, in the VBE, you can drag and drop the userform from one workbook to another within the project explorer window. It will copy the userform complete with its code.

Or you can right-click and export the userform to a folder and import it to the other workbook. Whichever works for you.

pingwin77
07-29-2009, 01:43 PM
awesome, thanks!