When you want to display a brief message, such as a warning, you can use a predefined dialog box called a message box. You can display a message box by adding the MsgBox action to a macro or by adding the MsgBox function to a Visual Basic procedure.
Display a message box by using a macro
Display a message box by using Visual Basic for Applications