Basics of VBA: Message Box

  

Bottom Line:

Learn how to use different VBA Message Box options.

Note:

Sample Excel with code included below. Please make use of it.

Skill Level: Beginner

Sample File: VBA-MessageBox.xlsm

 

Syntax:


Prompt − Required parameter, a string, that is displayed as a message in the dialog box.

All the others are optional parameters. Please check the below image for more info (Credits: Microsoft)


Various MessageBox options:

    1. with only 'Ok' button:

                                    

    Code:


2. with 'Ok' and 'Cancel' buttons:

                                   

    Code:

    


3. with 'Abort', 'Retry' and 'Ignore' buttons:

                                    

    Code:

    


4. with 'Yes', 'No' and 'Cancel' buttons:

                                    

    Code:

    


5. with 'Yes' and 'No' buttons:

                                    

    Code:

    

Comments

Post a Comment

Popular posts from this blog

Sending Gmails using Excel VBA

Image
  Bottom Line: Learn how to send Gmails using Excel VBA , with attachments and body text, to predefined or dynamic list of recipients. Important aspects such as configuration changes, that need to be done in Gmail and Visual Basic Editor , for the code to work as expected, are also covered here. Note : Macro Template and other useful links related to Gmail configuration changes are included within/at the end of the post. Please make use of them.   Skill Level: Beginner Sample File:  VbaToSendGmail.xlsm Prerequisite: Basic VBA Hands-on knowledge Gmail configuration changes Enabling Microsoft CDO for Windows 2000 Library   1. Basic VBA Hands-on knowledge: Assuming you already have some basic knowledge on how to enable Developer option, accessing different objects in Visual Basic Editor and basics programming knowledge, providing some useful links relevant to the topic. Please go through the below links to quickly brush up the concepts: Getting starte...
Read more