dialog box to pop up after macro is complete

[nabeel151]

The macro I have already put in automatically emails the excel file to an email address.

What I need:

Once the button is pushed, I just want a dialog box to pop up and say, "Your Inquiry has been submitted to....."

Then I would like the excel sheet to automatically close.

 

[madamson86]

Hi

Use the below for your dialog box

msgbox("Your Inquiry has been submitted to.....")

And the below to close your workbook

ActiveWorkbook.Close False
' closes the active workbook without saving any changes

ActiveWorkbook.Close True
' closes the active workbook and saves any changes

ActiveWorkbook.Close
' closes the active workbook and lets the user decide if
' changes are to be saved or not

 

[nabeel151]

Thank you very much. It worked like a charm