VBA Operation Excel's MsgBox function parameter detailed explanation

Source: Internet
Author: User
Tags chr constant expression numeric

First, function syntax

Function Name: MsgBox

function function: Displays a message in a dialog box, waits for the user to click the button, and returns an Integer telling the user which button to click.

function Syntax:

MsgBox (prompt[, buttons] [, title] [, HelpFile, context])

Parameter description:

The syntax for the MsgBox function has several named arguments:

Prompt: Required. A string expression that is the message that appears in the dialog box.

The maximum length of the prompt is approximately 1024 characters, determined by the width of the characters used.

If the contents of a prompt exceed a row, the rows can be separated by a carriage return (CHR (13)), a newline character (CHR (10)), or a combination of a carriage return and a newline character (Chr & Chr (10)).

Buttons: Optional. A numeric expression is the sum of the values, specifying the number and form of the display buttons, the icon style used, what the default button is, and the mandatory response of the message box. If omitted, the default value for buttons is 0.

Title: Optional. A string expression displayed in the title bar of the dialog box. If you omit title, the application name is placed in the title bar.

Helpfile: Optional. A string expression that identifies the Help file that is used to provide context-sensitive Help to the dialog box. If a helpfile is provided, the context must also be provided.

Context: Optional. A numeric expression that is assigned by the author of the Help file to the Help context number of the appropriate Help topic. If the context is provided, helpfile must also be provided.

Button parameter

Constant Value Description

vbOKOnly 0 Only displays the OK button

vbOKCancel 1 Displays the OK and Cancel buttons

Vbabortretryignore 2 Displays the Terminate, retry, and Ignore buttons

vbYesNoCancel 3 shows Yes, no and Cancel buttons

vbYesNo 4 shows Yes and no buttons

Vbretrycancel 5 Displays the Retry and Cancel buttons

vbcritical 16 Displays the "Key information" icon

Vbquestion 32 Displays the warning query icon

Vbexclamation 48 Displays the warning message icon

vbinformation 64 Displays the notification message icon

VbDefaultButton1 0 The first button is the default value (the default setting)

VbDefaultButton2 256 The second button is the default value

VbDefaultButton3 512 The third button is the default value

VbDefaultButton4 768 The fourth button is the default value

vbApplicationModal 0 Application force return; The application is suspended until the user has a message box

Respond before continuing to work

Vbsystemmodal 4096 system force return; All applications are suspended until the user responds to a message box to continue working

vbMsgBoxHelpButton 16384 Add the Help button to the message box

vbMsgBoxSetForeground 65536 Specifies the message box window as the foreground window

vbMsgBoxRight 524288 text for right alignment

vbMsgBoxRtlReading 1048576 Specifies that the text should be displayed from right to left in the Hebrew and Arabic systems


① the first set of values (0–5) describes the type and number of buttons displayed in a message box, the second set of values (16,32,48,64) describes the style of the icon, and the third set of values (0,256,512,768) indicates which button is the default, and the fourth set of values (0,4096) Determines the mandatory return of a message box. When these numbers are added to generate buttons parameter values, only one number can be fetched from each set of values.

① These constants are specified by Visual Basic for Applications (VBA). As a result, you can use these constant names everywhere in your program code without having to use actual values. The actual value is equivalent to the constant name.

return value

Constants for MsgBox function return values

Constant numerical description

vbOK 1 OK

Vbcancel 2 Cancel

Vbabort 3 terminated.

Vbretry 4 Retry

Vbignore 5 Ignore

Vbyes 6 is

Vbno 7 No

① If you provide both the HelpFile and the context parameters, you can press the F1 key to see the appropriate Help topic for the context, and Excel usually automatically adds a Help button to the input box.

② If you display the Cancel button in a message box, pressing the ESC key will have the same effect as clicking the Cancel button. If the Help button is available in the message box, provide related help information.

③ If you want to enter multiple parameters and omit some of the middle parameters, you must add a comma delimiter at the appropriate location.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.