| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro won't run macro | Excel Discussion (Misc queries) | |||
| Calculations And Order In Macros | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| Zip Code Macro | Excel Worksheet Functions | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
Hybrid Mode
