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

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

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

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

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

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/

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/

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/

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/