Macro message box

[ynissel]

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 Phillips]

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]

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]

Of course

Msgbox Range("A1").Value & "', your email has been sent", vbInformation

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[ynissel]

Thanks !

Of course

Msgbox Range("A1").Value & "', your email has been sent", vbInformation

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[blonde1030]

Hi Bob, jumping in here too: Do you know how to make a msgbox popup
automatically upon opening the file?

 

[Bob Phillips]

Yes, put it in a macro called Autpen, 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]

Most excellent, thanks!

Yes, put it in a macro called Autpen, or add it to the Workbook_Open
event in the ThisWorkbook code module.

--

HTH

RP
(remove nothere from the email address if mailing direct)