VBA Inputbox Msgbox Function

VBA InputBox MsgBox Function are two commonly used functions in VBA programming. InputBox is used to get input from the user, while MsgBox is used to display a message in a dialog box

Here is an example of how to use InputBox to get input from the user and store it in a variable:

Dim Name as String
name = InputBox ("Enter your name here")

Here is an example of how to use MsgBox to display a message in a dialog box:

MsgBox "Welcome to VBA "

VBA – InputBox Function

The InputBox function prompts the users to enter values.

Syntax: -
        InputBox (prompt [, title] [, default] [, xpos] [, ypos] [, helpfile, context])

The String Variable with an Input Box

Sub name_input()
Dim name As String
name = InputBox ("what is your name", "Student Detail", "type here")
MsgBox "The student name is " & name
End Sub

The Number Variable with an Input Box

Sub age_input()
Dim Age As Integer
Age = InputBox ("what is your age", "Student Detail", "type here")
MsgBox "The student age is " & Age
End Sub

VBA MsgBox Function

A MsgBox is nothing but a dialog box that you can use to inform your users by showing a custom message. The MsgBox function displays a message box and waits for the user to click a button and then an action is performed based on the button clicked by the user.

Syntax:
                   MsgBox (prompt [, buttons] [, title] [, helpfile, context])

MsgBox Buttons – vbOKOnly (Default)

If you only use the prompt and don’t specify any of the arguments, you will get the default message box as shown below:

Sub DefaultMsgBox()
MsgBox "Welcome to excel VBA family of myitschools"
End Sub

MsgBox Buttons – OK & Cancel

If you only want to show the OK and the Cancel button, you need to use the vbOKCancel constant.

Sub MsgBoxOKCancel()
MsgBox "Do you Want to Continue?", vbOKCancel
End Sub

MsgBox Buttons – Yes and No

You can use the ‘vbYesNo’ constant to show the Yes and No buttons.

Sub MsgBoxYesNo()
MsgBox "Do you like cricket?", vbYesNo
End Sub

MsgBox Buttons – Yes, No and Cancel

You can use the ‘vbYesNoCancel’ constant to show the Yes, No, and Cancel buttons.

Sub MsgBoxYesNoCancel()
MsgBox "Do you know about VBA msgbox?", vbYesNoCancel
End Sub

MsgBox Buttons – Abort, Retry, and Ignore

You can use the ‘vbAbortRetryIgnore’ constant to show the Abort, Retry, and the Ignore buttons.

Sub MsgBoxAbortRetryIgnore()
MsgBox "What do you want to do?", vbAbortRetryIgnore
End Sub

MsgBox Buttons – Help Button

You can use the ‘vbMsgBoxHelpButton’ constant to show the help button. You can use it with other button constants.

Sub MsgBoxRetryHelp()
MsgBox "What do you want to do next?", vbRetryCancel + vbMsgBoxHelpButton             
End Sub

MsgBox Icons – Critical

If you want to show a critical icon in your MsgBox, use the vbCritical constant. You can use this along with other button constants (by putting a + sign in between the codes).

For example, below is a code that will show the default OK button with a critical icon.

Sub MsgBoxCriticalIcon ()
MsgBox "Does there is any health issue?", vbCritical
End Sub

If you want to show the critical icon with Yes and No buttons, use the following code:

Sub MsgBoxCriticalI()
MsgBox "This is a sample box", vbYesNo + vbCritical
End Sub