Get Started

Enable Developer Tab:

1. Click at File → Options
2. Select Customize Ribbon → Customize the Ribbon → Main Tabs → Tick Developer
3. Click OK

Create your first VBA:

1. Click at Developer tab
2. Click Insert
3. Select Command Button (ActiveX Control)
4. Drag to any cells. Adjust the size to make it bigger
5. Then right click
6. Select View Code
7. A new screen will appear. This is VBA Editor
8. Place your cursor between Private Sub CommandButton1_Click() and End Sub
9. Type: Range("A1").Value="Hi, Welcome!"
10. Close the VBA Editor screen to go back to Excel
11. Go to Developer and switch off Design Mode by clicking at Design Mode
12. Then click at Command Button
13. You will see the result in cell A1
14. Congratulations! You have successfully created your first VBA

Alternative ways to open VBA Editor:

1. Go to Developer tab, click at Visual Basic to open VBA Editor OR
2. Right click at any worksheet, select View Code