VBA MSGBOX – A Complete Guide to Message Box Function + Examples


The first thing which I have learned about VBA was using a message box (“msgbox function”).

It’s like a simple popup box on your Excel window to show a specific message. If you think about it, you can use it in two ways.

  • Deliver a message to the user.
  • Get a simple response from the user.

Most of the VBA programmers use it in their macro codes to make them more interactive and if you are not familiar with it, I bet after reading this post you will fall in love with it.

Expert Tip: If you are a VBA newbie then learning about VBA message box can be a good idea.

So today in this post, I'd like to share with you all the details about using a message box in Excel and some of the real life examples.

...let's get started.



=MSGBOX(prompt, [buttons], [title], [helpfile, context])

syntax vba msgbox function
  • prompt A string expression used for displaying as a message. The maximum length of characters is 1024, which depends on the width of the characters.
  • [buttons] You can use this argument to specify buttons, icon style, button’s identity and modality of the message box.
  • [title] You can use this argument to specify a title text for your message box.
  • [helpfile] This argument will help you to specify a help file for the user. The user can access that help file using the help button. If you specify a help file, this mandatory to specify a context number.
  • [context] A numeric expression that uses to assign a help topic from the help menu.

Note: In the above list, arguments above which are in square brackets are optional, you can skip to specify them.

How to Customize a Message Box and use Different Buttons

You can easily customize a VBA message box with all the available options.

Let’s have a look at these options.

#1. vbOKOnly

This gives you a simple OK button. The user can click on it after reading the message to close it. You can also use further a macro to execute once the OK button is clicked.

Sub OKOnly()

MsgBox Prompt:="This is a MsgBox ", _

Buttons:=vbOKOnly, _


End Sub

#2. vbOKCancel

This constant gives you an OK and cancel button. Now the user has two options to press OK to proceed or cancel to exit.

Sub OKCancel()

MsgBox Prompt:="Is this OK", _

Buttons:=vbOKCancel, _


End Sub

#3. vbAbortRetryIgnore

This allows you to show three buttons for About, Retry and Ignore. The user can abort the operation, can retry or can ignore it.

Sub OKCancel()

MsgBox Prompt:="Is this OK", _

Buttons:=vbOKCancel, _


End Sub

#4. vbYesNoCancel

This constant shows three buttons for Yes, No and Cancel. The user can Yes to accept and proceed, No to reject or cancel to close the message box.

Sub YesNoCancel()

MsgBox Prompt:="Now, You have three buttons", _

Buttons:=vbYesNoCancel, _


End Sub

#5. vbYesNo

This constant shows two buttons for Yes and No. The user can click Yes to accept and proceed or No to reject.

Sub YesNo()

MsgBox Prompt:="Now, You have two buttons", _

Buttons:=vbYesNo, _


End Sub

#6. vbRetryCancel

Now this shows two buttons, retry and cancel. You can use this to ask the user to retry the operation or to cancel it.

Sub RetryCancel()
MsgBox Prompt:="Please Retry", _
Buttons:=vbRetryCancel, _
End Sub

#7. vbCritical

This constant shows an icon in the msg box, stating that the message is critical.


MsgBox Prompt:="This is critical", _

Buttons:=vbCritical, _


End Sub

#8. vbQuestion

This constant can use when you asking a question to the user.

Sub Question()

MsgBox Prompt:="What to do now?", _

Buttons:=vbQuestion, _


End Sub

#9. vbExclamation

This constant will show an exclamation icon with the message.

Sub Exclamation()

MsgBox Prompt:="What to do now?", _

Buttons:=vbExclamation, _


End Sub

#10. vbInformation

It will show an icon stating that the message is information.

Sub Information()
MsgBox Prompt:="What to do now?", _
Buttons:=vbInformation, _
End Sub

#11. vbDefaultButton1

Use this constant to specify the first button of your msg box as the default button.

Sub DefaultButton1()
MsgBox Prompt:="Button1 is Highlighted?", _
Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton1, _
End Sub

#12. vbDefaultButton2

Use this constant to specify the second button of your message box as the default button.

Sub DefaultButton2()
MsgBox Prompt:="Button2 is Highlighted?", _
Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton2, _
End Sub

#13. vbDefaultButton3

Use this constant to specify the third button of your msgbox as the default button.

Sub DefaultButton3()
MsgBox Prompt:="Button3 is Highlighted?", _
Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton3, _
End Sub

#14. vbDefaultButton4

Use this constant to specify the fourth button of your msgbox as the default button.

Sub DefaultButton4()
MsgBox Prompt:="Button4 is Highlighted?", _
Buttons:=vbYesNoCancel + vbMsgBoxHelpButton + vbDefaultButton4, _
End Sub

#15. vbAppliactionModal

This constant will suspend the application (Excel), User has to respond to the msgbox to use application.

Sub OKOnly()

MsgBox Prompt:="This is a MsgBox ", _

Buttons:=vbOKOnly, _

Title:="MsgBox", _

End Sub

#16. vbSystemModal

This constant will suspend all the applications in your OS, User has to respond to the msg box first.

Sub ApplicationModal()
MsgBox Prompt:="This is the Application Modal", _
Buttons:=vbOK + vbApplicationModal, _
End Sub

#17. vbMsgBoxHelpButton

Use this constant to add a help button to your msg box. You can add a help file & a context number to use the help button.

Sub HelpButton()
MsgBox Prompt:="Use Help Button", _
Buttons:=vbOK + vbMsgBoxHelpButton, _
Title:="MsgBox", _
HelpFile:="C:UsersPuneet GogiaDesktopsamplehelp.chm", _
End Sub

Once the user clicks on the help button, a help menu will appear.

#18. vbMsgBoxSetForeground

This constant will help you make your message box window a foreground window.

Sub SetForeground()
MsgBox Prompt:="This MsgBox is Foreground", _
Buttons:=vbOK + vbMsgBoxSetForeground, _
End Sub

#19. vbMsgBoxRight

The text will be aligned to the right by using this constant.

Sub MsgBoxRight()

MsgBox Prompt:="Text Is In Right", _

Buttons:=vbOK + vbMsgBoxRight, _


End Sub

#20. vbMsgBoxRtlReading

By using this constant, the message box will flip to the right. This constant is mainly designed for Hebrew and Arabic systems.

Sub MsgBoxRtlReading()

MsgBox Prompt:="This Box is Flipped", _

Buttons:=vbOK + vbMsgBoxRtlReading, _


End Sub

Returning Values

Whenever a user responds to the message box by clicking any of the buttons, a number is generated. This will help you to identify which button is clicked by the user.

























Real Life Examples to use VBA Message Box Function in Excel

Here I have listed some real life examples for VBA message box and I'm sure these examples will inspire you to use it.

#1. Run Macro With a VBA MsgBox

Now with the help of msgbox function, you can ask a user before running a macro. Let’s look the below macro to understand.

Sub SaveThis()

Dim Result As Integer

Result = MsgBox("Do you want to save this file?", vbOKCancel)

If Result = vbOK Then


End Sub

save workbook with vba msgbox

You can ask the user to save the workbook and if the user clicks on the OK button the macro code will save the workbook.