560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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:
A simple message box, without any customisation at all.
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.
|Parts of this blog|
25 Aytoun Street