<\/span>Excel VBA MsgBox Button Constants (Examples)<\/span><\/h2>\nIn this section, I will cover the different types of buttons that you can use with a VBA MsgBox.<\/p>\n
Before I show you the VBA code for it and how the MsgBox looks, here is a table that lists all the different button constants you can use.<\/p>\n
\n\n\nButton Constant<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n\n| vbOKOnly<\/td>\n | Shows only the OK button<\/td>\n<\/tr>\n | \n| vbOKCancel<\/td>\n | Shows the OK and Cancel buttons<\/td>\n<\/tr>\n | \n| vbAbortRetryIgnore<\/td>\n | Shows the Abort, Retry, and Ignore buttons<\/td>\n<\/tr>\n | \n| vbYesNo<\/td>\n | Shows the Yes and No buttons<\/td>\n<\/tr>\n | \n| vbYesNoCancel<\/td>\n | Shows the Yes, No, and Cancel buttons<\/td>\n<\/tr>\n | \n| vbRetryCancel<\/td>\n | Shows the Retry and Cancel buttons<\/td>\n<\/tr>\n | \n| vbMsgBoxHelpButton<\/td>\n | Shows the Help button. For this to work, you need to use the help and context arguments in the MsgBox function<\/td>\n<\/tr>\n | \n| vbDefaultButton1<\/td>\n | Makes the first button default. You can change the number to change the default button. For example, vbDefaultButton2 makes the second button as the default<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n Note: While going through the examples of creating different buttons, you may wonder what’s the point of having these buttons if it doesn’t have any impact on the code. <\/span><\/p>\nIt does! Based on the selection, you can code what you want the code to do. For example, if you select OK, the code should continue, and if you click Cancel, the code should stop. This can be done by using variables and assigning the value of the Message Box to a variable. We will cover this in the later sections of this tutorial.<\/span><\/p>\nNow let’s have a look at some examples of how the different buttons can be displayed in a MsgBox and how it looks.<\/p>\n MsgBox Buttons – vbOKOnly (Default)<\/h3>\nIf you only use the prompt and don’t specify any of the arguments, you will get the default message box as shown below:<\/p>\n ![\"Sample](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/07\/Excel-VBA-Msgbox-Sample-Default.png\") <\/p>\n
Below is the code that will give this message box:<\/p>\n Sub DefaultMsgBox()\nMsgBox \"This is a sample box\"\nEnd Sub<\/pre>\nNote that the text string needs to be in double quotes.<\/p>\n You can also use the button constant\u00a0vbOKOnly, but even if you don’t specify anything, it’s taken as default.<\/p>\n MsgBox Buttons – OK & Cancel<\/h3>\nIf you only want to show the OK and the Cancel button, you need to use the vbOKCancel constant.<\/p>\n Sub MsgBoxOKCancel()\nMsgBox \"Want to Continue?\", vbOKCancel\nEnd Sub<\/pre>\n![\"ok](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/07\/Excel-VBA-Msgbox-ok-and-cancel.png\") <\/p>\n
MsgBox Buttons – Abort, Retry, and Ignore<\/h3>\nYou can use the ‘vbAbortRetryIgnore’ constant to show the Abort, Retry, and the Ignore buttons.<\/p>\n Sub MsgBoxAbortRetryIgnore()\nMsgBox \"What do you want to do?\", vbAbortRetryIgnore\nEnd Sub<\/pre>\n![\"Excel](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/07\/Excel-VBA-Msgbox-Abort-Retry-Cancel.png\") <\/p>\n
MsgBox Buttons – Yes and No<\/h3>\nYou can use the ‘vbYesNo’ constant to show the Yes and No buttons.<\/p>\n Sub MsgBoxYesNo()\nMsgBox \"Should we stop?\", vbYesNo\nEnd Sub<\/pre>\n![\"Yes](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/07\/Excel-VBA-Msgbox-Yes-and-No.png\") <\/p>\n
MsgBox Buttons – Yes, No and Cancel<\/h3>\nYou can use the ‘vbYesNoCancel’ constant to show the Yes, No, and Cancel buttons.<\/p>\n Sub MsgBoxYesNoCancel()\nMsgBox \"Should we stop?\", vbYesNoCancel\nEnd Sub<\/pre>\n![\"Excel](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/07\/Excel-VBA-Msgbox-Yes-and-No-and-Cancel.png\") <\/p>\n
MsgBox Buttons – Retry and Cancel<\/h3>\nYou can use the ‘vbRetryCancel’ constant to show the Retry and Cancel buttons.<\/p>\n Sub MsgBoxRetryCancel()\nMsgBox \"What do you want to do next?\", vbRetryCancel\nEnd Sub<\/pre>\n![\"Retry](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/07\/Excel-VBA-Messagebox-Retry-and-Cancel.png\") <\/p>\n
MsgBox Buttons – Help Button<\/h3>\nYou can use the ‘vbMsgBoxHelpButton’ constant to show the help button. You can use it with other button constants.<\/p>\n Sub MsgBoxRetryHelp()\nMsgBox \"What do you want to do next?\", vbRetryCancel + vbMsgBoxHelpButton\nEnd Sub<\/pre>\n![\"help](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/07\/Excel-VBA-Msgbox-help-button.png\") <\/p>\n
Note that in this code, we have combined two different button constants (vbRetryCancel + vbMsgBoxHelpButton<\/strong>). The first part shows the Retry and Cancel buttons and the second part shows the Help button.<\/p>\nMsgBox Buttons – Setting a Default Button<\/h3>\nYou can use the ‘vbDefaultButton1’ constant to set the first button as default. This means that the button is already selected and if you press enter, it executes that button.<\/p>\n Below is the code that will set the second button (the ‘No’ button) as the default.<\/p>\n Sub MsgBoxOKCancel()\nMsgBox \"What do you want to do next?\", vbYesNoCancel + vbDefaultButton2\nEnd Sub<\/pre>\n![\"by](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/07\/Excel-VBA-Msgbox-default-button-2.png\") <\/p>\n
In most cases, the left-most button is the default button. You can choose other buttons using\u00a0vbDefaultButton2,\u00a0vbDefaultButton3, and\u00a0vbDefaultButton4.<\/p>\n | | |