Excel Office 365 VBA Overview ~ Definition and Examples!!
Tags: excelpreface, vbaoverviewinexcel, exceltutorials
Published: 2020-12-15 10:57:37

---
title: Excel Office 365 VBA Overview ~ Definition and Examples!!
published: True
date: 2020-12-15 10:37:38 UTC
tags: ExcelPreface,VBAOverviewinExcel,ExcelTutorials
canonical_url: https://geekexcel.com/excel-office-365-vba-overview-definition-and-examples/
---

 **VBA** stands for **Visual Basic for Applications** which is the programming language for Excel. [VBA](https://geekexcel.com/shortcut-to-open-vba-editor-in-microsoft-excel-365/) is used to automate tasks and perform plenty of operations or functions. You can easily automate some tasks that you need to use repetitively.

Let’s see the **Excel Office 365 VBA Overview** with the clear-cut screenshots and examples.
## VBA – Definition:

- [VBA](https://geekexcel.com/shortcut-to-open-vba-editor-in-microsoft-excel-365/) is an event-driven programming language in Microsoft Excel.
- This programming language will automate the tasks that you are using frequently.
- You can also use the shortcut **ALT** + **F11** keys to open the VBA window.
- In the below image, you can see the window of VBA. This can be used to develop a VBA program

![VBA window](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/VBA-window.png)<figcaption id="caption-attachment-19705">VBA window</figcaption>

## Display the Developer Tab in the Ribbon:

To open the Excel VBA editor window, you need to enable the “ **Develop Tab** ” on the ribbon. Kindly, follow the below steps to display the developer tab.

- Go to the **File Tab,** then **select** the **Options** option from the menu.

![Click Options](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Click-Options.png)<figcaption id="caption-attachment-19711">Click Options</figcaption>

- It will **display the Excel Options window**.
- You need to **select** the **Customize Ribbon** option from the left pane.
- Then, you need to **enable** the **Developer checkbox** under the **Main Tabs** section which is located on the right-side.
- Then, **click** the **OK** button.

![Excel Options window](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Excel-Options-window-1.png)<figcaption id="caption-attachment-19712">Excel Options window</figcaption>

- Now, you will see the **Developer Tab** in the Ribbon as shown in the below screenshot.
- You can see the five groups under this Developer Tab such as **Code, Add\_ins, Controls, XML,** and **Modify.**

![Developer Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Developer-Tab.png)<figcaption id="caption-attachment-19713">Developer Tab</figcaption>

## Open the Visual Basic Editor:

If you want to open the Visual Basic Editor window, follow the below steps.

- Go to the **Developer Tab, click** the **Visual Basic** button under the **Code** group.

![Select the Visual Basic button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Visual-Basic-button.png)<figcaption id="caption-attachment-19714">Select the Visual Basic button</figcaption>

- Then, you will see the **Visual Basic Editor** window.

![VBA window](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/VBA-window.png)<figcaption id="caption-attachment-19705">VBA window</figcaption>

## VBA Windows:

Here, we are going to explore the windows in the Visual Basic Editor window.

- The following are the windows available in **VBA Editor**.
- **Project Explorer, Properties Window, Code Window, Immediate window,** and **Watch Window.**
- If you want to open any of the above-mentioned windows, you need to **click** the **View** option. It will show the list of windows as shown in the below image.

![View option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/View-option.png)<figcaption id="caption-attachment-19715">View option</figcaption>

![Another windows](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Another-windows.png)<figcaption id="caption-attachment-19716">Other windows</figcaption>

## A Short Summary:

I hope, this article might be useful to know the **Excel Office 365 VBA Overview** with the clear-cut screenshots and examples. Please share your **queries** in the comment section given below. Share your **suggestions** as well so that we can improve our services. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!