The Message Box In VBA

=> One of the best functions in Visual Basic is the Message box. The message box displays a message, optional icon, and selected set of command buttons. The user responds by clicking a button.

=> The statement form of the message box returns no value (it simply displays the box ) :-

MsgBox Message, Type, Title

where

Message     Text message to be displayed
Type            Type of message box (discussed in a bit)
Title             Text in title bar of message box
You have no control over where the message box appears on the screen.

=>  The function form of the message box returns an integer value (corresponding to the button clicked by            the user). Example of use (Response is returned value) :-

Dim Response as Integer
Response = MsgBox(Message, Type, Title)

=>  The Type argument is formed by summing four values corresponding to the buttons to display, any icon to show, which button is the default response, and the morality of the message box.

=>  The first component of the Type value specifies the buttons to display :-
Value     Meaning                                                  Symbolic Constant

0        OK button only                                            vbOKOnly
1       OK/Cancel buttons                                        vbOKCancel
2       Abort/Retry/Ignore buttons                             vbAbortRetryIgnore
3       Yes/No/Cancel buttons                                  vbYesNoCancel
4       Yes/No buttons                                              vbYesNo
5       Retry/Cancel buttons                                      vbRetryCancel

Comments

Post a Comment

jeetexceltips@gmail.com

Popular posts from this blog

50 Excel VBA Oral Interview Questions

Ques 01. What is the difference between ByVal and ByRef and which is default ? Solution: ByRef: If you pass an argument by reference when calling a procedure the procedure access to the actual variable in memory. As a result the variable's value can be changed by the procedure. ByVal: If you pass an argument by value when calling a procedure the variable's value can be changed with in the procedure only outside the actual value of the variable is retained. ByRef is default: Passing by reference is the default in VBA. If you do not explicitly specify to pass an argument by value VBA will pass it by reference. Ques 02. What is the meaning of Option Explicit and Option Base? Solution: Option Explicit makes the declaration of Variables Mandatory while Option Base used at module level to declare the default lower bound for array subscripts. For eg. Option Base 1 will make the array lower bound as 1 instead of 0. Option Base - When an array is declared by d...
Read more