Thanks. Ed

"Chip Pearson" wrote in message
...
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



"Ed" wrote in message
...
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

"Chip Pearson" wrote in message
...
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 "

wrote in message
...
right click on the userform module in the project explorer.
select
export file and save it. send this file to the concerned
person
and ask
him to import it in his excel sheet by using the same
method.
Right
click in the forms and select import file, browse to the
location where
the file is and import.

- Mangesh


---
Message posted from http://www.ExcelForum.com/