Posts

Showing posts with the label MsgBox In VBA Excel

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 correspond...