VBA MsgBox Title helps the user to quickly understand the message prompt. We can add MsgBox Window Title and Change it Dynamically. Here is the syntax to add, change and format the Message Box Title in VBA.
What is MsgBox Title Bar
MsgBox Title Bar is a Window Title Bar of the Message Dialog Box in VBA. It helps the VBA developer to add a suitable title to the MsgBox.
Here is the MsgBox syntax to set the Title. You can add required Caption to the Title of MsgBox in VBA using the Title Parameter. MsgBox Function provided with a Title argument. Title is an Optional Parameter of Message Box . You can add a String expression to displayed in the title bar of the message dialog box.
Title Argument:
MsgBox (prompt, [ buttons, ] [ title, ] [ helpfile, context ])
Adding MsgBox Title
Here is a simple VBA Macro to add a Title to the Message Box. We can use the Title argument to set the required Title of the Application. You can pass any string variable or a enter any string as title.
Sub sb_VBA_MsgBox_Title() MsgBox Prompt:="Enter the Prompt to show in the Message Box", Title:="Enter Title of the MSG Box Window" End Sub
Default Title of MsgBox
Title is an Optional Argument of MsgBox function. If the title argument is left empty, the application name is displayed in the title bar. Here are the default Title of the MS Office Applications.
- Word: ‘Microsoft Word’ is the default title of the MS Word VBA.
- Excel: Excel VBA shows ‘Microsoft Excel’ as the default Title.
- Access: ‘Microsoft Access’ is the default title of the MS Access VBA.
- PPT: PowerPoint VBA shows ‘Microsoft PowerPoint ‘ as the default Title.
Excel VBA MsgBox Title
Here is the VBA code to add MsgBox Title in Excel VBA. It will display the ‘Microsoft Excel’ as the default Titles in the Excel Application. You can change using Excel VBA Functions as shown below.
Sub sb_ExcelVBA_MsgBox_Title() 'String as Title MsgBox Prompt:=Sheets(1).Range("A5"), Title:="Showing the Data From Range A5" 'Cell value as Title MsgBox Prompt:=Sheets(1).Range("A5"), Title:=Sheets(1).Range("A1") 'Variable as Title strTitle="This is Excel VBA MsgBox Title" MsgBox Prompt:="Your message", Title:=strTitle End Sub
Access VBA MsgBox Title
Similarly, We can as add Title to Message Box in Access VBA. It will display the ‘Access Excel’ as the default Titles in the Access Application. You can change using Access VBA Functions as shown below.
Sub sb_AccessVBA_MsgBox_Title() 'String as Title MsgBox Prompt:="Required prompt string", Title:="Required Stringin Access" 'Variable as Title strTitle="Today is: " & Date MsgBox Prompt:="Your message", Title:=strTitle End Sub
VBA Yes No MsgBox Title
Yes No MsgBox Title argument is very useful while displaying Message Box with Yes and No Options. You can simply ask a question to the user and ask them to press Yes or No based on their decision.
Sub sb_VBA_MsgBox_YesNo_Title() If MsgBox("Enter the Prompt to show in the Message Box", vbYesNo, "Do You Wants to Continue?") = vbYes Then 'Statements to run when user press the Yes Button MsgBox "Yes Button Pressed" Else 'Statements to run when user press the No Button MsgBox "No Button Pressed" End If End Sub
Formatting the Title
You can use the VBA format function to format the string as required and show in the title. You can format the text as date, numbers and time.
You can not format the default font styles of the message dialog box. You can temporarily change the Windows Application Dialog Box Settings to change the Font Styles. You can change the Title Font Color, Font weight to Bold or italic. And set it back to default options using Windows APIs. We strongly recommend you to use Userform to create message box with required options, instead of changing through Windows APIs.
Best Practices
Here are the best practices to follow while adding the Title to the Message Box in VBA.
- Title should be shorter in length. Long title will increase the size of the MsgBox Window.
- Use MsgBox Title to display a short title of the topic. And place the description message in the prompt area.
- Try to add Section Name of the Code while displaying Error Messages.
- You can get any value from your workbook, document, slide or data base and display as title using a string variable.
- Use the the Userforms to create custom message boxes to change the font styles and background color of the MsgBox.