| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email forms
How can I set a command button to automatically close and then email a
completed user form? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
When the workbooks is closed (or emailed) the values in the userform will be
lost. You need to write the values to a worksheet and mail the worksheet or take a snapshot of the userform and paste that to a worksheet and mail the worksheet. http://support.microsoft.com/default.aspx?kbid=161514 XL97: How to Use a UserForm for Entering Data http://support.microsoft.com/default.aspx?kbid=213749 XL2000: How to Use a UserForm for Entering Data -- Regards, Tom Ogilvy "mast" wrote in message ... How can I set a command button to automatically close and then email a completed user form? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| Email, forms, Excel, Infopath, Sharepoint | Excel Discussion (Misc queries) | |||
| Calling Forms from Forms - Exit problems | Excel Programming | |||
| Using Excel / VBA to automatically email forms - how? | Excel Programming | |||
Hybrid Mode
