Posted to microsoft.public.excel.programming

No Name

Posts: n/a

Adding Message to Spreadsheet

Thank yo for your assistance, that is just what I needed
-----Original Message-----

When the user clicks on the OK button you need to add the
xldialogsendmail ... ie.
ans = msgbox("What you want to say", vbyesno)
if ans = vbyes then
Application.Dialogs(xlDialogSendMail).Show
"), "NameofDocument"
end if

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error message when adding a name	matelot	Charts and Charting in Excel	3	May 11th 07 02:05 PM
Adding the message body to a mailto macro	Mike	Excel Discussion (Misc queries)	0	March 28th 06 03:06 AM
Adding message window	Guido van Lammeren	Excel Discussion (Misc queries)	2	October 7th 05 11:12 PM
Adding an error message at close of file when criteria are met	Dave	Excel Discussion (Misc queries)	3	August 12th 05 07:56 PM
can I add a flashing message to a spreadsheet?	little_one_30	Excel Worksheet Functions	1	July 20th 05 02:50 PM

All times are GMT +1. The time now is 09:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us