The MsgBox function displays a message box, waits for the user to click a button, and returns a value that indicates which button the user clicked.
The MsgBox function can return one of the following values:
Note: The user can press F1 to view the Help topic when both the helpfile and the context parameter are specified.
Tip: Also look at the InputBox function.
|prompt||Required. The message to show in the message box. Maximum length is 1024 characters. You can separate the lines using a carriage return character (Chr(13)), a linefeed character (Chr(10)), or carriage return–linefeed character combination (Chr(13) & Chr(10)) between each line|
|buttons|| Optional. A value or a sum of values that specifies the
number and type of buttons to display, the icon style to use, the identity
of the default button, and the modality of the message box. Default value is
We can divide the buttons values into four groups: The first group (0–5) describes the buttons to be displayed in the message box, the second group (16, 32, 48, 64) describes the icon style, the third group (0, 256, 512, 768) indicates which button is the default; and the fourth group (0, 4096) determines the modality of the message box. When adding numbers to create a final value for the buttons parameter, use only one number from each group
|title||Optional. The title of the message box. Default is the application name|
|helpfile||Optional. The name of a Help file to use. Must be used with the context parameter|
|context||Optional. The Help context number to the Help topic. Must be used with the helpfile parameter|
A messagebox with a line feed:
Different buttonsets and different icons. Returns the value of the clicked button:
A messagebox with a title:
The perfect solution for professionals who need to balance work, family, and career building.
More than 10 000 certificates already issued!
The HTML Certificate documents your knowledge of HTML.
The HTML5 Certificate documents your knowledge of advanced HTML5.
The CSS Certificate documents your knowledge of advanced CSS.
The jQuery Certificate documents your knowledge of jQuery.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
Your message has been sent to W3Schools.