Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, and 2013. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Using Message Boxes.

Using Message Boxes

by Allen Wyatt
(last updated June 23, 2018)

1

When you create macros in Word, you can easily incorporate the use of message boxes. These are typically used to convey information to the user and to get some rudimentary input. You include message boxes by using the MsgBox command. The following portion of a macro creates a very simple message box:

MsgBox "The macro is done"

You can also add symbols to your message boxes by including a symbol-type code as part of your MsgBox invocation. These symbols are used extensively in many Windows dialog boxes. The following four types of symbols can be used:

Type Enumeration Symbol
16 vbCritical White X in a red circle (and "ding")
32 vbQuestion Question mark in a circle
48 vbExclamation Exclamation point in a circle
64 vbInformation Information symbol (lowercase i in a circle)

You can use either the number in the Type column or the enumeration in the Enumeration column with the MsgBox statement. As an example, let's suppose you wanted to include the exclamation point symbol. This is typically included in dialog boxes as a notice of when something important has happened or is about to happen. To include this symbol in your message box, you would include either of the following code lines:

MsgBox "Can't run the macro on the text", 48
MsgBox "Can't run the macro on the text", vbExclamation

So far the MsgBox command has been used as a statement, but you can also use it as a function. If you do so, you can use it to get simple input from the user. To make the MsgBox function more useful, Word allows you to display more clickable buttons in the dialog box besides the OK button. This is done by adjusting the type code, which was used for the symbols displayed in the message box. The following are the different button combinations you can display in your message box:

Type Enumeration Button Types
1 vbOKCancel OK, Cancel
2 vbAbortRetryIgnore Abort, Retry, Ignore
3 vbYesNoCancel Yes, No, Cancel
4 vbYesNo Yes, No
5 vbRetryCancel Retry, Cancel

To use the buttons, you simply add the value of the button type to the value you want used for the symbol. You can use either the values in the Type column or the enumerations in the Enumeration column; VBA doesn't care which is used. In the previous example, you used the code of 48 or enumeration of vbExclamation to display the exclamation point symbol. If you wanted to also include the Abort, Retry, Ignore buttons, you could simply use the following code lines:

J = MsgBox "Can't run the macro on the text", 48 + 2
J = MsgBox "Can't run the macro on the text", vbExclamation + vbAbortRetryIgnore

If you choose to use numeric values, you can actually add the values together. In other words, you could use "50" instead of "48 + 2". After the code line is executed, J will be equal to a value that indicates which button was clicked. In doing your testing to see what J is equal to, it is best to use enumerations, but you could use values. Here are the possible return values:

Value Enumeration Button Clicked
1 vbOK OK
2 vbCancel Cancel
3 vbAbort Abort
4 vbRetry Retry
5 vbIgnore Ignore
6 vbYes Yes
7 vbNo No

Should you use values or enumerations with MsgBox? It really boils down to personal preference, but there are two major advantages to using enumerations. First, when you are typing the VBA code, the editor automatically offers "hints" as to the available enumerations. Second, the enumerations are more descriptive in your code, meaning you can more easily see what their effect is within MsgBox. Third, the enumerations protect you against any possible changes that Microsoft may make to how MsgBox works in the future. This isn't to say that Microsoft will make changes; the values shown in this tip have been static for years. But if they do change the values, the enumerations will continue to work because Microsoft simply changes the meanings of the enumerations behind-the-scenes.

Note:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (8931) applies to Microsoft Word 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Word here: Using Message Boxes.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Automatically Selecting Words

When editing a document, Word normally selects entire words as you use the mouse to select text. This tip explains why ...

Discover More

Adding a Hyperlink to a Document

As an online tool, it makes sense that Docs allows you to create hyperlinks that lead to other resources online. Here's ...

Discover More

Determining Your Serial Number

The serial number assigned to your copy of Excel is valuable. It allows you to get support and is necessary for some ...

Discover More

The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!

More WordTips (ribbon)

Determining if a Text Selection Exists

Macros are often designed to be run on just a selected portion of a document. It is a good idea to make sure that the ...

Discover More

Understanding the If ... End If Structure

One of the powerful programming structures provided in VBA allows you to conditionally execute commands. The If ... End ...

Discover More

Removing Shortcuts for Macros

Word apparently has a bug in it that makes it very difficult to remove a shortcut key previously associated with a macro. ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 5 - 2?

2014-06-10 07:03:53

Bryan

I'm glad to see you have taken my suggestions and fixed the errors in the article. However, it still needs work.

Clarity issues aside, the "J = MsgBox "Can't run the macro on the text", 48 + 2" and "J = MsgBox "Can't run the macro on the text", vbExclamation + vbAbortRetryIgnore" lines don't work -- they won't even pass the real time compiler! When you are using the MsgBox function to pass a variable, you have to put its inputs in parentheses like so: J = MsgBox("Can't run the macro on the text", vbExclamation + vbAbortRetryIgnore)


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.