Using MsgBox to Display Messages in VBA Macros
Part one of a five-part series of blogs

The MsgBox command in Visual Basic for Applications allows you to display basic messages, but you can also make it prettier, and even use it to ask questions or display multiple-line messages! Read on to find out more about this versatile VBA command.

  1. Using MsgBox to Display Messages in VBA Macros (this blog)
  2. Displaying Message Boxes
  3. Joining Bits of a Message Together
  4. Customising your Message Box
  5. Using MsgBox to Ask Questions

This blog is part of our Excel macros online tutorial series.  Our main business is running training courses in Excel, courses in VBA and training in many other Microsoft applications.

Posted by Andy Brown on 28 September 2011

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Using MsgBox to Display Messages in VBA Macros

Whether you're writing Visual Basic for Applications code in Excel, Access, PowerPoint, Word or any other application, you can use the MsgBox command to display a pop-up message on screen. 

Don't confuse message boxes with input boxes, the subject of a separate blog.  Message boxes display a message on screen; input boxes ask you to type something in.

Message boxes thus displayed can be simple:

Simple message box

A simple message box, without any customisation at all.

 

Or customised:

A customised MsgBox message box

In this message box, we've changed the titles and buttons and added a question mark symbol.

 

If you want to customise your message boxes more than this, you're out of luck - you can only add so many bells and whistles.  In such a case you're best off creating a user form, which you can format as much as you like.

Without further ado, then, let's look at what you can do to create a message box ... beginning with what it is and the basic syntax.

This blog has 0 threads Add post