ExcelVBATutor
Lesson 1

Introduction to Excel VBA 365

In this lesson, you will learn what Excel VBA is, why it is useful, and how to create your first macro in Microsoft Excel 365.

❮ Tutorial Home Next Lesson ❯

What is Excel VBA?

Excel VBA, or Visual Basic for Applications, is the built-in programming language inside Microsoft Excel. It lets you automate repetitive tasks, create custom solutions, and extend what Excel can do.

With VBA, you can record or write macros, create your own functions, build forms, and interact with workbooks, worksheets, and ranges in a much more powerful way than by using formulas alone.

With Excel VBA, you can:
✓ Automate routine spreadsheet work
✓ Create custom functions
✓ Build user-friendly forms and tools
✓ Work more efficiently with data

Why learn VBA in Excel 365?

VBA remains one of the most practical ways to turn Excel into a productivity tool. In business, education, finance, engineering, and administration, VBA helps users save time and reduce manual work.

  1. Automate repetitive tasks: Generate reports, format sheets, and process data faster.
  2. Build custom tools: Create calculators, dashboards, forms, and workflow helpers.
  3. Improve job skills: VBA is still valuable in many spreadsheet-heavy roles.
  4. Work smarter: Combine Excel features with code to make solutions more powerful.
  5. Understand Excel better: VBA teaches you how Excel objects and actions really work.

Write your first macro

Follow these steps to open the VBA editor and create a simple macro.

Step 1: Show the Developer tab

  1. Go to File > Options.
  2. Select Customize Ribbon.
  3. Check Developer, then click OK.
Developer tab in Excel 365
Figure 1.1. Adding the Developer tab to the Excel Ribbon.

Step 2: Open the Visual Basic Editor

Click the Developer tab and then choose Visual Basic. This opens the VBA editor where you write and manage macro code.

Excel VBA Editor
Figure 1.2. The VBA editor interface in Excel 365.

Step 3: Insert a module

  1. In the Project pane, right-click your workbook project.
  2. Choose Insert > Module.
Insert module in VBA
Figure 1.3. Inserting a new module for your code.

Step 4: Type your first macro

Enter the following code in the module window:

Sub HelloWorld()
    MsgBox "Welcome to Excel VBA 365"
End Sub

This macro shows a message box. It is a simple but useful starting point for understanding how VBA procedures work.

Message box in Excel VBA
Figure 1.4. Running a simple message box macro.

Step 5: Run the macro

  1. Return to Excel.
  2. Open the Developer tab and click Macros.
  3. Select HelloWorld and click Run.
Tip: Save your workbook as a Macro-Enabled Workbook (.xlsm) so your VBA code is preserved.

Lesson summary

  • Excel VBA is the programming language built into Microsoft Excel.
  • It helps automate repetitive tasks and create custom spreadsheet solutions.
  • The Developer tab gives you access to the VBA editor and macros.
  • Your first macro can be as simple as showing a message box.
❮ Excel VBA 365 Next Lesson ❯