On this page, you will learn how to write a simple macro in a step by step manner.
Step 1 − First, enable 'Developer' menu in Excel 20XX. To do the same, click File Options.
Step 2 − Click ‘Customize the Ribbon’ tab and check 'Developer'. Click 'OK'.
![](images/forum/201707021343331230.jpg)
Step 3 − The 'Developer' ribbon appears in the menu bar.
![](images/forum/201707021346517117.jpg)
Step 4 − Click the 'Visual Basic' button to open the VBA Editor.
![](images/forum/201707021348329269.jpg)
Step 5 − Start scripting by adding a button. Click Insert Select the button.
![](images/forum/201707021353167234.jpg)
Step 6 − Perform a right-click and choose 'properties'.
![](images/forum/201707021358475077.jpg)
Step 7 − Edit the name and caption as shown in the following screenshot.
![](images/forum/201707021400452257.jpg)
Step 8 − Now double-click the button and the sub-procedure outline will be displayed as shown in the following screenshot.
![](images/forum/201707021402285234.jpg)
Step 9 − Start coding by simply adding a message.
Private Sub say_helloworld_Click()
MsgBox "Hi"
End Sub
Step 10 − Click the button to execute the sub-procedure. The output of the sub-procedure is shown in the following screenshot.
![](images/featured/201707021406312416.png)
Note − In further chapters, we will demonstrate using a simple button, as explained from step#1 to 10. Hence , it is important to understand this chapter thoroughly.