Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

MsgBox Statement

Displays a dialogue box containing a message.

Syntax:


   MsgBox prompt As String [,buttons = MB-OK [,title As String]]
   response = MsgBox( prompt As String [,buttons = MB-OK [,title As String]])

Parameters:

prompt: String expression displayed as a message in the dialogue box. Line breaks can be inserted with Chr$(13).

title: String expression displayed in the title bar of the dialogue box. If omitted, the title bar displays the name of the respective application.

buttons: Any integer expression that specifies the dialogue box type, as well as the number and type of buttons to display, and the icon type. buttons represents a combination of bit patterns, that is, a combination of elements can be defined by adding their respective values:

Named constant Integer value Definition
MB-OK 0 Display OK button only.
MB-OKCANCEL 1 Display OK and Cancel buttons.
MB-ABORTRETRYIGNORE 2 Display Abort, Retry, and Ignore buttons.
MB-YESNOCANCEL 3 Display Yes, No, and Cancel buttons.
MB-YESNO 4 Display Yes and No buttons.
MB-RETRYCANCEL 5 Display Retry and Cancel buttons.
MB-ICONSTOP 16 Add the Stop icon to the dialog.
MB-ICONQUESTION 32 Add the Question icon to the dialog.
MB-ICONEXCLAMATION 48 Add the Exclamation Point icon to the dialog.
MB-ICONINFORMATION 64 Add the Information icon to the dialog.
128 First button in the dialog as default button.
MB-DEFBUTTON2 256 Second button in the dialog as default button.
MB-DEFBUTTON3 512 Third button in the dialog as default button.

Error codes:

5 Invalid procedure call

Example:


Sub ExampleMsgBox
 Const sText1 = "An unexpected error occurred."
 Const sText2 = "The program execution will continue, however."
 Const sText3 = "Error"
 MsgBox(sText1 + Chr(13) + sText2,16,sText3)
 MsgBox(sText1 + Chr(13) + sText2, MB-ICONSTOP, sText3)
End Sub