{"id":8572,"date":"2023-02-13T17:57:33","date_gmt":"2023-02-13T17:57:33","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=8572"},"modified":"2023-12-13T19:09:57","modified_gmt":"2023-12-13T19:09:57","slug":"vba-msgbox-function","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/vba-msgbox-function\/","title":{"rendered":"VBA MsgBox Function"},"content":{"rendered":"<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-9974\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-MsgBox.jpg\" alt=\"VBA message box featured image\" width=\"800\" height=\"600\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-MsgBox.jpg 800w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-MsgBox-300x225.jpg 300w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-MsgBox-768x576.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<div class=\"top-style-2\">\n<p>To interact with the users of your application, you may create dialog boxes. In VBA, a dialog box can be created by using the <strong>MsgBox function<\/strong>.<\/p>\n<ul>\n<li>The MsgBox enables the creation of dialog boxes with many options.<\/li>\n<li>For example, a dialog box is displayed before quitting the application. In that case, you may ask the user \u201cAre you sure you want to quit?\u201d with <em>Yes and No<\/em> options.<\/li>\n<li>Similarly, before performing a critical operation like deleting records, a dialog box appears confirming the user with a message and <em>OK\/Cancel<\/em> options.<\/li>\n<li>You may set all these options (Yes\/No, OK\/Cancel, etc.) along with the message displayed to the user by using MsgBox function.<\/li>\n<\/ul>\n<\/div>\n<h3><strong>Syntax of MsgBox in VBA<\/strong><\/h3>\n<p>For creating a dialog, the general syntax is:<\/p>\n<div class=\"codediv\">MsgBox(prompt[, buttons] [, title] [, helpfile, context])<\/div>\n<p>These arguments for MsgBox are explained below:<\/p>\n<table width=\"1128\">\n<tbody>\n<tr>\n<td width=\"362\"><span style=\"color: #008000;\"><strong>Argument<\/strong><\/span><\/td>\n<td width=\"766\"><span style=\"color: #008000;\"><strong>Description<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td><strong>prompt<\/strong><\/td>\n<td>\n<ul>\n<li>This is the only <strong>required<\/strong> argument.<\/li>\n<li>The prompt is a string that appears to the user.<\/li>\n<li>For example, \u201cAre you Sure?\u201d.<\/li>\n<li>You may display any message there as per the requirement. However, the length of the message is limited \u2013around 1024 characters.<\/li>\n<li>The limit also depends on the character width e.g. capital letters may take more space than small letters.<\/li>\n<li>The carriage return character (Chr(13)) can be used for adding lines in the dialog box message.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td><strong>Button<\/strong><\/td>\n<td>This is an <strong>optional<\/strong> argument. If you do not provide a value, the default is taken, which is 0.<\/p>\n<p>That is, the dialog appears with \u2018OK\u2019 button only.<\/td>\n<\/tr>\n<tr>\n<td><strong>Title\u00a0<\/strong><\/td>\n<td>This specifies the message that appears in the <strong>title bar<\/strong> of the message box. If not provided, the default is the application name.<\/td>\n<\/tr>\n<tr>\n<td><strong>helpfile\u00a0<\/strong><\/td>\n<td>It is used to provide context-sensitive help. If you provide the helpfile then context is also required.<\/td>\n<\/tr>\n<tr>\n<td><strong>context\u00a0<\/strong><\/td>\n<td>The context is in relation to the helpfile. This is a <strong>numeric<\/strong> expression.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><strong>An example of simple MsgBox VBA<\/strong><\/h3>\n<p>The first example simply displays the message in a dialog box with \u2018Ok\u2019 button. For that, just enclose the message without specifying a button, so the default is taken. Have a look at the code:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Function MsgBox_exmample()\r\n\r\n\u00a0\u00a0 'A simple message in dialog\r\n\r\n\u00a0\u00a0 MsgBox (\"Welcome to the VBA World!\")\r\n\r\nEnd Function<\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-4541 size-full\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.1-VBA-msgbox.png\" alt=\"VBA msgbox\" width=\"224\" height=\"167\" \/><\/p>\n<p>As no button value is specified, it took the 0 value which is just the \u2018OK\u2019 button.<\/p>\n<h3><strong>A demo of message box with Yes\/No buttons<\/strong><\/h3>\n<p>The <strong>button value = 4<\/strong> displays the button with Yes and No options in the message box.<\/p>\n<p>See the example and code below with a Yes\/No alert with a simple message. No other action is performed in this example as you click Yes or No.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Function MsgBox_exmample()\r\n\r\n\u00a0\u00a0 'A Demo of Yes and No\r\n\r\n\u00a0\u00a0 a = MsgBox(\"Dialog with Yes\/No!\", 4)\r\n\r\nEnd Function<\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-4542 size-full\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.2-msgbox-Yes-No.png\" alt=\"msgbox Yes No\" width=\"260\" height=\"240\" \/><\/p>\n<h3><strong>The example of Yes\/No\/Cancel buttons with title<\/strong><\/h3>\n<div class=\"inner-info-div\">If you want to create a dialog with <em>Yes, No, and Cancel<\/em> options then use the button <strong>value = 3<\/strong>.<\/div>\n<p>See the following example where this value is used along with the title option. As mentioned earlier, the title will appear in the title bar of the message box:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Function MsgBox_exmample()\r\n\u00a0\u00a0 'buttn value = 3 with Yes\/No\/Cancel\r\n\u00a0\u00a0 numa = MsgBox(\"Yes\/No and Cancel options!\", 3, \"Yes, No and Cancel Demo\")\r\n\r\n\u00a0\u00a0 If numa = 6 Then\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 MsgBox \"Yes option pressed!\"\r\n\u00a0\u00a0 ElseIf numa = 7 Then\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 MsgBox \"No option pressed!\"\r\n\u00a0\u00a0 Else\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 MsgBox \"Cancel pressed!\"\r\n\u00a0\u00a0 End If\r\n\r\nEnd Function<\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-4543 size-full\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.3-msgbox-Yes-No-cancel.png\" alt=\"msgbox Yes No cancel\" width=\"364\" height=\"205\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.3-msgbox-Yes-No-cancel.png 364w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.3-msgbox-Yes-No-cancel-300x169.png 300w\" sizes=\"(max-width: 364px) 100vw, 364px\" \/><\/p>\n<p>In the demo, you can see another simple dialog appear with the message that which button was pressed. This is done by accessing the returned value of the button. Pressing the button returns the following values:<\/p>\n<ul>\n<li>If Yes is pressed, <strong>it returns 6<\/strong>.<\/li>\n<li>If Cancel is pressed, <strong>it returns 7<\/strong>.<\/li>\n<li>For Cancel, <strong>it returns 2.<\/strong><\/li>\n<li>See the complete list in the bottom section.<\/li>\n<\/ul>\n<p>The <a href=\"\/vba-if-elseif-else-statement\/\">VBA If..ElseIf..Else statement<\/a> is used to get the value and display the respective dialog box.<\/p>\n<h3><strong>A demo of a multi-line VBA message box<\/strong><\/h3>\n<p>For this demo, a multiline message box is created by using <strong>vbNewLine<\/strong>. Apart from that, button constant <strong>vbQuestion <\/strong>is used rather than a numeric value.<\/p>\n<p>Have a look at the code and output:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Function MsgBox_exmample()\r\n\r\n\u00a0\u00a0 'buttn value = vbQuestion\r\n\r\n\u00a0\u00a0 x = MsgBox(\"Demo of multiline\" &amp; vbNewLine &amp; \"message box\" &amp; vbNewLine &amp; \"Three Lines\", vbQuestion, \"Multi-Line Box\")\r\n\r\n\u00a0\u00a0\r\n\r\nEnd Function<\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-4544 size-full\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.4-msgbox-multi-line-box.png\" alt=\"msgbox multi line box\" width=\"231\" height=\"197\" \/><\/p>\n<div class=\"note-div\"><em><strong>Note<\/strong><\/em>: See the list of button values with constants below.<\/div>\n<h3><strong>Using a combination of two buttons \u2013 changing the default button<\/strong><\/h3>\n<p>In the Yes\/No\/Cancel example, you might notice there is a default button. The default button is pressed as you close the dialog using the space bar or escape key etc. If you try that example again, you will see the \u2018Yes\u2019 button is the default.<\/p>\n<p>For changing this to some other button like No or Cancel, you may use the combination of two buttons by using a <strong>\u2018+\u2019 sign<\/strong>.<\/p>\n<p>Have a look at the code below and run this example, press the spacebar or escape key to close the dialog and see what the next dialog displays:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Function MsgBox_exmample()\r\n\r\n \u00a0 'button value = 3 + vbDefaultButton3\r\n\u00a0\u00a0 numa = MsgBox(\"Press escape or space bar!\", 3 + vbDefaultButton3, \"Two buttons demo\")\r\n\r\n\u00a0\u00a0 If numa = 6 Then\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 MsgBox \"Yes pressed!\"\r\n\u00a0\u00a0 ElseIf numa = 7 Then\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 MsgBox \"No pressed!\"\r\n\u00a0\u00a0 Else\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 MsgBox \"Cancel pressed!\"\r\n\u00a0\u00a0 End If\r\n\r\nEnd Function<\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-4545 size-full\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.5-msgbox-multi-buttons.png\" alt=\"msgbox multi buttons\" width=\"366\" height=\"170\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.5-msgbox-multi-buttons.png 366w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.5-msgbox-multi-buttons-300x139.png 300w\" sizes=\"(max-width: 366px) 100vw, 366px\" \/><\/p>\n<p>You saw the Cancel button became the default. This is done by using the following combination:<\/p>\n<div class=\"codediv\">3 + vbDefaultButton3<\/div>\n<p>The <strong>vbDefaultButton3<\/strong> button is used to make the third button default. Similarly, the <em>vbDefaultButton1, vbDefaultButton2, and vbDefaultButton4<\/em> make the 1, 2, and 4 buttons default, respectively.<\/p>\n<h3><strong>Adding a Help button with a critical icon<\/strong><\/h3>\n<p>This dialog is the combination of three buttons.<\/p>\n<ul>\n<li>The <strong><em>vbYesNo<\/em><\/strong> displays two options: Yes and No.<\/li>\n<li>The <strong><em>vbCritical<\/em><\/strong> is added for the critical sign with Windows sound.<\/li>\n<li>The third button is a Help button by using the constant: <strong><em>vbMsgBoxHelpButton<\/em><\/strong>.<\/li>\n<\/ul>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Function MsgBox_exmample()\r\n\r\n\u00a0\u00a0 'A demo of showing help button with critcal icon\r\n\r\n\u00a0\u00a0 numa = MsgBox(\"Are you sure deleting this account permanently?\", vbYesNo + vbCritical + vbMsgBoxHelpButton, \"Help button demo\")\r\n\r\nEnd Function<\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-4546 size-full\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.6-msgbox-help.png\" alt=\"msgbox help\" width=\"387\" height=\"193\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.6-msgbox-help.png 387w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/1.6-msgbox-help-300x150.png 300w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/p>\n<h3><strong>List of buttons with constants, values, and description<\/strong><\/h3>\n<p>Following is the button list that you may specify in the MsgBox with the value and a little description:<\/p>\n<table data-sourcepos=\"3:1-24:85\">\n<tbody>\n<tr data-sourcepos=\"3:1-3:41\">\n<th data-sourcepos=\"3:1-3:17\"><span style=\"color: #008000;\">Button Constant<\/span><\/th>\n<th data-sourcepos=\"3:19-3:25\"><span style=\"color: #008000;\">Value<\/span><\/th>\n<th data-sourcepos=\"3:27-3:39\"><span style=\"color: #008000;\">Description<\/span><\/th>\n<\/tr>\n<tr data-sourcepos=\"5:1-5:67\">\n<td data-sourcepos=\"5:1-5:10\">VbOkOnly<\/td>\n<td data-sourcepos=\"5:12-5:14\">0<\/td>\n<td data-sourcepos=\"5:16-5:65\">This is the default and displays the OK button only.<\/td>\n<\/tr>\n<tr data-sourcepos=\"6:1-6:47\">\n<td data-sourcepos=\"6:1-6:12\">vbOKCancel<\/td>\n<td data-sourcepos=\"6:14-6:16\">1<\/td>\n<td data-sourcepos=\"6:18-6:45\">For OK and Cancel buttons.<\/td>\n<\/tr>\n<tr data-sourcepos=\"7:1-7:61\">\n<td data-sourcepos=\"7:1-7:15\">vbYesNoCancel<\/td>\n<td data-sourcepos=\"7:17-7:19\">3<\/td>\n<td data-sourcepos=\"7:21-7:59\">Displays Yes, No, and Cancel buttons.<\/td>\n<\/tr>\n<tr data-sourcepos=\"8:1-8:46\">\n<td data-sourcepos=\"8:1-8:9\">vbYesNo<\/td>\n<td data-sourcepos=\"8:11-8:13\">4<\/td>\n<td data-sourcepos=\"8:15-8:44\">Displays Yes and No buttons.<\/td>\n<\/tr>\n<tr data-sourcepos=\"9:1-9:71\">\n<td data-sourcepos=\"9:1-9:20\">vbAbortRetryIgnore<\/td>\n<td data-sourcepos=\"9:22-9:24\">2<\/td>\n<td data-sourcepos=\"9:26-9:69\">Displays Abort, Retry, and Ignore buttons.<\/td>\n<\/tr>\n<tr data-sourcepos=\"10:1-10:58\">\n<td data-sourcepos=\"10:1-10:15\">vbRetryCancel<\/td>\n<td data-sourcepos=\"10:17-10:19\">5<\/td>\n<td data-sourcepos=\"10:21-10:56\">Displays Retry and Cancel buttons.<\/td>\n<\/tr>\n<tr data-sourcepos=\"11:1-11:55\">\n<td data-sourcepos=\"11:1-11:12\">vbCritical<\/td>\n<td data-sourcepos=\"11:14-11:17\">16<\/td>\n<td data-sourcepos=\"11:19-11:53\">Displays a critical message icon.<\/td>\n<\/tr>\n<tr data-sourcepos=\"12:1-12:52\">\n<td data-sourcepos=\"12:1-12:12\">vbQuestion<\/td>\n<td data-sourcepos=\"12:14-12:17\">32<\/td>\n<td data-sourcepos=\"12:19-12:50\">Displays a question mark icon.<\/td>\n<\/tr>\n<tr data-sourcepos=\"13:1-13:59\">\n<td data-sourcepos=\"13:1-13:15\">vbExclamation<\/td>\n<td data-sourcepos=\"13:17-13:20\">48<\/td>\n<td data-sourcepos=\"13:22-13:57\">Displays an exclamation mark icon.<\/td>\n<\/tr>\n<tr data-sourcepos=\"14:1-14:54\">\n<td data-sourcepos=\"14:1-14:15\">vbInformation<\/td>\n<td data-sourcepos=\"14:17-14:20\">64<\/td>\n<td data-sourcepos=\"14:22-14:52\">Displays an information icon.<\/td>\n<\/tr>\n<tr data-sourcepos=\"15:1-15:64\">\n<td data-sourcepos=\"15:1-15:18\">vbDefaultButton1<\/td>\n<td data-sourcepos=\"15:20-15:22\">0<\/td>\n<td data-sourcepos=\"15:24-15:62\">Sets the first button as the default.<\/td>\n<\/tr>\n<tr data-sourcepos=\"16:1-16:67\">\n<td data-sourcepos=\"16:1-16:18\">vbDefaultButton2<\/td>\n<td data-sourcepos=\"16:20-16:24\">256<\/td>\n<td data-sourcepos=\"16:26-16:65\">Sets the second button as the default.<\/td>\n<\/tr>\n<tr data-sourcepos=\"17:1-17:66\">\n<td data-sourcepos=\"17:1-17:18\">vbDefaultButton3<\/td>\n<td data-sourcepos=\"17:20-17:24\">512<\/td>\n<td data-sourcepos=\"17:26-17:64\">Sets the third button as the default.<\/td>\n<\/tr>\n<tr data-sourcepos=\"18:1-18:67\">\n<td data-sourcepos=\"18:1-18:18\">vbDefaultButton4<\/td>\n<td data-sourcepos=\"18:20-18:24\">768<\/td>\n<td data-sourcepos=\"18:26-18:65\">Sets the fourth button as the default.<\/td>\n<\/tr>\n<tr data-sourcepos=\"19:1-19:67\">\n<td data-sourcepos=\"19:1-19:20\">vbApplicationModal<\/td>\n<td data-sourcepos=\"19:22-19:24\">0<\/td>\n<td data-sourcepos=\"19:26-19:65\">Modal to the current application only.<\/td>\n<\/tr>\n<tr data-sourcepos=\"20:1-20:67\">\n<td data-sourcepos=\"20:1-20:15\">vbSystemModal<\/td>\n<td data-sourcepos=\"20:17-20:22\">4096<\/td>\n<td data-sourcepos=\"20:24-20:65\">Modal to all applications in the system.<\/td>\n<\/tr>\n<tr data-sourcepos=\"21:1-21:71\">\n<td data-sourcepos=\"21:1-21:20\">vbMsgBoxHelpButton<\/td>\n<td data-sourcepos=\"21:22-21:28\">16384<\/td>\n<td data-sourcepos=\"21:30-21:69\">Adds a Help button to the message box.<\/td>\n<\/tr>\n<tr data-sourcepos=\"22:1-22:77\">\n<td data-sourcepos=\"22:1-22:23\">VbMsgBoxSetForeground<\/td>\n<td data-sourcepos=\"22:25-22:31\">65536<\/td>\n<td data-sourcepos=\"22:33-22:75\">Brings the message box to the foreground.<\/td>\n<\/tr>\n<tr data-sourcepos=\"23:1-23:84\">\n<td data-sourcepos=\"23:1-23:15\">vbMsgBoxRight<\/td>\n<td data-sourcepos=\"23:17-23:24\">524288<\/td>\n<td data-sourcepos=\"23:26-23:82\">Aligns the message box to the right side of the screen.<\/td>\n<\/tr>\n<tr data-sourcepos=\"24:1-24:85\">\n<td data-sourcepos=\"24:1-24:20\">vbMsgBoxRtlReading<\/td>\n<td data-sourcepos=\"24:22-24:30\">1048576<\/td>\n<td data-sourcepos=\"24:32-24:83\">Enables right-to-left reading for the message box.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><strong>Table of returned values for different buttons<\/strong><\/h3>\n<table width=\"1128\">\n<tbody>\n<tr>\n<td width=\"362\"><span style=\"color: #008000;\"><strong>Button<\/strong><\/span><\/td>\n<td width=\"766\"><span style=\"color: #008000;\"><strong>Returned Value<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td width=\"362\">Ok<\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td width=\"362\">Cancel<\/td>\n<td>2<\/td>\n<\/tr>\n<tr>\n<td>Yes<\/td>\n<td>6<\/td>\n<\/tr>\n<tr>\n<td>No<\/td>\n<td>7<\/td>\n<\/tr>\n<tr>\n<td>Abort<\/td>\n<td>3<\/td>\n<\/tr>\n<tr>\n<td>Retry<\/td>\n<td>4<\/td>\n<\/tr>\n<tr>\n<td>Ignore<\/td>\n<td>5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In VBA, the dialog box can be created by using the MsgBox function. The MsgBox enables creating dialog boxes with many options.<\/p>\n","protected":false},"author":1,"featured_media":9974,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[147],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v14.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Learn VBA MsgBox (5 Examples): Yes\/No, Ok, Cancel and other options<\/title>\n<meta name=\"description\" content=\"In VBA, the dialog box can be created by using the MsgBox function. The MsgBox enables creating dialog boxes with many options.\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excel-learn.com\/vba-msgbox-function\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn VBA MsgBox (5 Examples): Yes\/No, Ok, Cancel and other options\" \/>\n<meta property=\"og:description\" content=\"In VBA, the dialog box can be created by using the MsgBox function. The MsgBox enables creating dialog boxes with many options.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/vba-msgbox-function\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-13T17:57:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-13T19:09:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-MsgBox.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/vba-msgbox-function\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-MsgBox.jpg\",\"width\":800,\"height\":600,\"caption\":\"VBA message box featured image\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/vba-msgbox-function\/#webpage\",\"url\":\"https:\/\/www.excel-learn.com\/vba-msgbox-function\/\",\"name\":\"Learn VBA MsgBox (5 Examples): Yes\/No, Ok, Cancel and other options\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/vba-msgbox-function\/#primaryimage\"},\"datePublished\":\"2023-02-13T17:57:33+00:00\",\"dateModified\":\"2023-12-13T19:09:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"description\":\"In VBA, the dialog box can be created by using the MsgBox function. The MsgBox enables creating dialog boxes with many options.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/vba-msgbox-function\/\"]}]},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8572"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=8572"}],"version-history":[{"count":5,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8572\/revisions"}],"predecessor-version":[{"id":9978,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8572\/revisions\/9978"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/9974"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=8572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=8572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=8572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}