Displaying Messages and Alerts in Excel Visual Basic

The MsgBox() function can be used to display alerts or prompts and even get some feedback from users.

The general format is:

MsgBox(MessageString, Buttons, Title, HelpFile, Context)

Buttons, Title, HelpFile, and Context are all optional, leaving your basic required function call:

MsgBox(MessageString)

OR

MsgBox MessageString

The optional Buttons parameter uses a Numerical Constant. You can either use the Constant variable name or the value it represents. The purpose of the Buttons is to display a button to the user in order to receive feedback.

When you create a message box using the various buttons, you get a possible return value:

Example 1: A Simple Message Box

Private Sub CommandButton1_Click()
     MsgBox "Hello"
 End Sub

Example 2: Message Box with a Return Value

Private Sub CommandButton1_Click()
     Dim MsgBoxReturnValue As Integer
    
     MsgBoxReturnValue = MsgBox("Do you like pancakes?", vbYesNo + vbCritical, "Important Question")
    
     If (MsgBoxReturnValue = vbYes) Then
         MsgBox "YES!", vbInformation, "You Answered:"
     Else
         MsgBox "NO!", vbInformation, "You Answered:"
     End If
 End Sub

The above code will first create this message box:

Answering “Yes” will produce this response:

Answering “No” will produce this response:

Excel VBA Resources