|
Macro message box
How do I get my macro to pop up a message box that says "your email has been
sent" and just an OK button to continue ? Thanks |
msgbox "Your email has been sent", vbInformation
It5 also shows one of those information buttons. -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... How do I get my macro to pop up a message box that says "your email has been sent" and just an OK button to continue ? Thanks |
Bob,
Great - thanks, worked like a charm ! Can I spiff it up - like input the users name from a specific cell (a1) into the statement ? Yosef "Bob Phillips" wrote: msgbox "Your email has been sent", vbInformation It5 also shows one of those information buttons. -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... How do I get my macro to pop up a message box that says "your email has been sent" and just an OK button to continue ? Thanks |
Of course
Msgbox Range("A1").Value & "', your email has been sent", vbInformation -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... Bob, Great - thanks, worked like a charm ! Can I spiff it up - like input the users name from a specific cell (a1) into the statement ? Yosef "Bob Phillips" wrote: msgbox "Your email has been sent", vbInformation It5 also shows one of those information buttons. -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... How do I get my macro to pop up a message box that says "your email has been sent" and just an OK button to continue ? Thanks |
Thanks !
"Bob Phillips" wrote: Of course Msgbox Range("A1").Value & "', your email has been sent", vbInformation -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... Bob, Great - thanks, worked like a charm ! Can I spiff it up - like input the users name from a specific cell (a1) into the statement ? Yosef "Bob Phillips" wrote: msgbox "Your email has been sent", vbInformation It5 also shows one of those information buttons. -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... How do I get my macro to pop up a message box that says "your email has been sent" and just an OK button to continue ? Thanks |
Hi Bob, jumping in here too: Do you know how to make a msgbox popup
automatically upon opening the file? "Bob Phillips" wrote: Of course Msgbox Range("A1").Value & "', your email has been sent", vbInformation -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... Bob, Great - thanks, worked like a charm ! Can I spiff it up - like input the users name from a specific cell (a1) into the statement ? Yosef "Bob Phillips" wrote: msgbox "Your email has been sent", vbInformation It5 also shows one of those information buttons. -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... How do I get my macro to pop up a message box that says "your email has been sent" and just an OK button to continue ? Thanks |
Yes, put it in a macro called Auto_Open, or add it to the Workbook_Open
event in the ThisWorkbook code module. -- HTH RP (remove nothere from the email address if mailing direct) "blonde1030" wrote in message ... Hi Bob, jumping in here too: Do you know how to make a msgbox popup automatically upon opening the file? "Bob Phillips" wrote: Of course Msgbox Range("A1").Value & "', your email has been sent", vbInformation -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... Bob, Great - thanks, worked like a charm ! Can I spiff it up - like input the users name from a specific cell (a1) into the statement ? Yosef "Bob Phillips" wrote: msgbox "Your email has been sent", vbInformation It5 also shows one of those information buttons. -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... How do I get my macro to pop up a message box that says "your has been sent" and just an OK button to continue ? Thanks |
Most excellent, thanks!
"Bob Phillips" wrote: Yes, put it in a macro called Auto_Open, or add it to the Workbook_Open event in the ThisWorkbook code module. -- HTH RP (remove nothere from the email address if mailing direct) "blonde1030" wrote in message ... Hi Bob, jumping in here too: Do you know how to make a msgbox popup automatically upon opening the file? "Bob Phillips" wrote: Of course Msgbox Range("A1").Value & "', your email has been sent", vbInformation -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... Bob, Great - thanks, worked like a charm ! Can I spiff it up - like input the users name from a specific cell (a1) into the statement ? Yosef "Bob Phillips" wrote: msgbox "Your email has been sent", vbInformation It5 also shows one of those information buttons. -- HTH RP (remove nothere from the email address if mailing direct) "ynissel" wrote in message ... How do I get my macro to pop up a message box that says "your has been sent" and just an OK button to continue ? Thanks |
| All times are GMT +1. The time now is 01:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com