Quick Userform Question

[mahmed1]

Hi, I have a userform already templated in one workbook.

Is there a quick way of copying that user form and paste it on another workbook (Worksheet). I dont want to redo the whole userform and was wondering if you could copy/paste on user forms?

Thanks

 

[Smitty]

Are you talking about a VBA User Form, or a worksheet form?

For a VBA form, in the VBE/Project Explorer you can just drag the form from wb1 to wb2 and that will create a copy of it.

For a worksheet form, you can right click on the sheet tab-->Move or Copy, then follow the wizard.

HTH,

 

[mahmed1]

Are you talking about a VBA User Form, or a worksheet form?

For a VBA form, in the VBE/Project Explorer you can just drag the form from wb1 to wb2 and that will create a copy of it.

For a worksheet form, you can right click on the sheet tab-->Move or Copy, then follow the wizard.

HTH,

Thank You (I was on about the VBA Form)