Send UserForm to Other Workbook with VBA

[mezr]

I've got a large workbook that has the capability of having (via VBA) selected sheets sent by email either one at a time, or together. It creates a new workbook and copies those sheets into it, attaches the new workbook to an email, then deletes the new workbook.

Is it possible to also send a copy of a userform from the original workbook into the temporary workbook by using VBA?

 

[Juan Pablo González]

You could export the Userform from the original workbook, and then import it in the new workbook...

See this for a guide on working with that sort of code:

http://www.cpearson.com/excel/vbe.htm

 

[dk]

Hi,

You may also want to take a look at this thread http://www.mrexcel.com/board2/viewtopic.php?t=58813 as it shows the code needed for doing this.

 

[mezr]

Thank you so much Juan and dk.

Both excellent links. I'm going to have a ton of fun with the possibilities that this opens up!