How to use Message Boxes for messages and alerts

In this lesson we cover:

• The basic Message Box with Prompt and Title
• How to add buttons (OK / Yes / No / Cancel)
• How to set the default button on a Message Box
• How to add alerts (Critical / Query / Warning / Information)
• What to do when the user presses a button
• A simple way to combine different buttons and alerts using a variable (e.g. Config = vbYesNo + vbCritical + vbDefaultButton2)

Note: You can find a list of Button constants, Alerts constants and Return values in the downloadable Module 7 workbook

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]