Use Message Boxes Sparingly

In Excel you can create message boxes using Visual Basic. Novice designers can get tempted to overuse message boxes. Having message boxes can be irritating and distracting to users of a spreadsheet-based DSS.

Message boxes work best to check actions prior to execution and to provide conclusions from logic embedded in the DSS.

To create a message box, in the Visual Basic editor, use the Message Box function. The syntax is MsgBox Prompt, Buttons, Title, where Prompt is the message that appears in the message box, Buttons is the type of buttons that appear in the message box, and Title is the title of the message box. You may want to store the value the user clicked on in the message box for later use in scripts.