How to use MsgBox function in VBA?

In VBA (Visual Basic for Applications), the MsgBox function is used to display a message box to the user and optionally get a response. The message box can display a message, a title, buttons, and an icon. Here’s how to use the MsgBox function:

MsgBox(prompt, [buttons], [title], [helpfile], [context])
prompt: The text displayed in the message box. This is the only required parameter. buttons: Optional. Specifies the buttons, icon, default button, and modality of the message box. It’s usually specified using constants (e.g., vbYesNoCancel, vbInformation, vbExclamation). title: Optional. The text displayed in the title bar of the message box. If omitted, the application name is used. helpfile: Optional. The name of the help file to use to provide context-sensitive help for the dialog box. context: Optional. The context ID number of the help topic within the help file specified in helpfile. Here’s a simple example of using the MsgBox function:

Sub ShowMessage()
    Dim response As Integer
    response = MsgBox("Do you want to continue?", vbYesNo + vbQuestion, "Continue Confirmation")
    If response = vbYes Then
        MsgBox "User chose Yes"
    ElseIf response = vbNo Then
        MsgBox "User chose No"
    End If
End Sub
In this example, we: 1. Display a message box with the Yes and No buttons and a question mark icon. The text “Do you want to continue?” will appear in the message box, and “Continue Confirmation” will be the title of the message box. 2. Capture the user’s response in the response variable. 3. Based on the user’s choice (Yes or No), we display another message indicating the user’s choice. Here are some of the commonly used constants for the buttons argument to define which buttons and icons appear in the message box: vbOKOnly: Displays only the OK button. vbOKCancel: Displays OK and Cancel buttons. vbAbortRetryIgnore: Displays Abort, Retry, and Ignore buttons. vbYesNoCancel: Displays Yes, No, and Cancel buttons. vbYesNo: Displays Yes and No buttons. vbRetryCancel: Displays Retry and Cancel buttons. vbCritical: Displays the Critical Message icon. vbQuestion: Displays the Warning Query icon. vbExclamation: Displays the Warning Message icon. vbInformation: Displays the Information Message icon. vbDefaultButton1: First button is default. vbDefaultButton2: Second button is default. vbDefaultButton3: Third button is default. vbApplicationModal: Application modal; the user must respond to the message box before continuing work in the current application. vbSystemModal: System modal; all applications are suspended until the user responds to the message box. These constants can be combined using the + operator. For instance, vbYesNo + vbQuestion will display a message box with Yes and No buttons and a question mark icon. Remember, MsgBox can return various values depending on the buttons pressed by the user. For example, if you use vbYesNo, the function will return vbYes if the user clicks Yes and vbNo if the user clicks No.

Unlock Your Potential


Basic - Advanced


Access Basic - Advanced

Power BI

Power BI Basic - Advanced

Help us grow the project

Leave a Reply

Your email address will not be published. Required fields are marked *