Chapter 5 – MsgBox and InputBox

In this chapter, we will learn how to use common Input and Output methods in VBA. We will also see practical examples of each method.

• MsgBox
• InputBox

Msgbox function is used to show an alert or message to user in form of dialog box.  This function is normally used to show confirmation of the action taken or take inputs from user in form of yes or no.

Commonly used Buttons in MsgBox:

Example 1: A normal message box

Code:

MsgBox ("World is beautiful")

Result:

Example 2: Message box with Yes and No buttons

Code:

MsgBox "Are you sure?", vbYesNo

Result:

Example 3: Message box with Title

Code:

MsgBox "Are you sure?", vbYesNo, "Confirmation"

Result:

Example 4: Message box with Information Message Icon

Code:

MsgBox "Task is completed", vbInformation, "Confirmation"

Result:

Example 5: Message box with Critical Message Icon

Code:

MsgBox "Task could not be completed", vbCritical, "Error"

Result:

Example 6: Message box with Abort, Retry and Ignore buttons

Code:

MsgBox "Task could not be completed" & vbNewLine & "Want to retry?", vbAbortRetryIgnore, "Error"

Result:

Displays a dialog box to accept input from user. This function is normally used to take simple input from user in form of string.

Example 1: Simple Input dialog box

Code:

InputBox ("What is your name?")

Result:

Example 2: Input box with title and default value

Code:

InputBox "How many sheets to be added?", "Sheets", 3

Result: