What is the difference between msgbox statement and msgbox function

Sign In. Don't have an account? Register now. Sign In using. Already a user? Sign in to JobBuzz. Please enter a valid email id. Password mandatory! Forgot password? Not you? Not using TJ? The example uses MsgBox to display a close without saving message in a dialog box with a Yes button a No button and a Cancel button.

The Cancel button is the default response. The MsgBox function returns a value based on the button chosen by the user. The MsgBox statement uses that value to display a message that indicates which button was chosen. HLP" ' Define Help file.

The first group of values describes the number and type of buttons displayed in the dialog box; the second group 16, 32, 48, 64 describes the icon style; the third group 0, , determines which button is the default; and the fourth group 0, determines the modality of the message box.

When adding numbers to create a final value for the buttons argument, use only one number from each group. These constants are specified by Visual Basic for Applications. As a result, the names can be used anywhere in your code in place of the actual values.

Some host applications , for example, Microsoft Excel, also automatically add a Help button to the dialog box. If the dialog box displays a Cancel button, pressing the ESC key has the same effect as clicking Cancel. If the dialog box contains a Help button, context-sensitive Help is provided for the dialog box. However, no value is returned until one of the other buttons is clicked.

To specify more than the first named argument, you must use MsgBox in an expression. To omit some positional arguments , you must include the corresponding comma delimiter.

This example uses the MsgBox function to display a critical-error message in a dialog box with Yes and No buttons. The No button is specified as the default response. The value returned by the MsgBox function depends on the button chosen by the user.

It is just like function and procedure. Msgbox functions returns the value,but the statement displays just we type in " ". It does not return any value. Please Turn OFF your ad blocker. Learn More. What is the difference between Msgbox Statement and MsgboxQ function? Interview Candidate Aug 27th, 6