Distribute Userform?

[Ed]

A co-worker wants a macro, and I think it would be best to give it to him in
a UserForm. I've emailed macro code over before, and just had them copy and
paste into their macro storage. But how do I send over a UserForm? All
code will be in the form.

Ed

 

[mangesh_yadav]

right click on the userform module in the project explorer. selec
export file and save it. send this file to the concerned person and as
him to import it in his excel sheet.

- Manges

 

[mangesh_yadav]

right click on the userform module in the project explorer. selec
export file and save it. send this file to the concerned person and as
him to import it in his excel sheet by using the same method. Righ
click in the forms and select import file, browse to the location wher
the file is and import.

- Manges

 

[Chip Pearson]

For Userforms, you need to send both the frm and the frx files.
When you export a userform, VBA creates two files, one called
FormName.frm and one called FormName.frx. Both files are
required to import the userform in to another project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"mangesh_yadav >" <<[email protected]>
wrote in message
news:[email protected]...

 

[Ed]

Thanks, Chip. I saw both and was wondering. When the user receives the
email and saves the files from it onto his system, does it matter where he
saves the files to?

Ed

For Userforms, you need to send both the frm and the frx files.
When you export a userform, VBA creates two files, one called
FormName.frm and one called FormName.frx. Both files are
required to import the userform in to another project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"mangesh_yadav >" <<[email protected]>
wrote in message

 

[Chip Pearson]

The only restriction is that both the frm and the frx files must
be saved in the same folder.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Thanks, Chip. I saw both and was wondering. When the user receives the
email and saves the files from it onto his system, does it matter where he
saves the files to?

Ed

 

[Ed]

Thanks. Ed

The only restriction is that both the frm and the frx files must
be saved in the same folder.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com