How To Make Message On Excel Using Macro

Example of code to make message on microsoft excel using macro:

1. First, make minimal code required on excel macro:
   

   Sub namaSub() End Sub

2. Add code to make message on excel macro:
   

   Sub namaSub()   MsgBox "Text will appear as message" End Sub

   To run its macro, on menu choose Run > Run Sub/UserForm, or click on Run button which symbolized with green triangle, or press F5 button on keyboard.
3. Message content can be changed, example:

   Sub namaSub()   MsgBox "Welcome to ms excel, use pc wisely... ;)" End Sub

4. To show message can be used Function procedure:
   

   Function namaFunction()   MsgBox "Welcome to ms excel, use pc wisely... ;)" End Function

Source:
Tutorial Excel Indonesia: https://www.youtube.com/watch?v=CjeC1lqQuwI

Posted in: