VBA Architecture

 VBA| Developer Tab & VBA Architecture | Part-2

In this blog we will discuss about what is "Developer Tab" and the "Architecture of VBA". So let's start our discussion with what is Developer Tab, how to add the developer tab in excel.

Developer Tab - The Developer tab is a built in tab in Excel, provides the features needed to use in Visual Basic for Applications and perform a macro operation. The developer tab is disabled by default. It must be enabled first in the Options section under File menu to make it visible on the toolbar at the top of Excel Window.

Now let's take a look at the steps to add Developer tab in Excel which are as follows:-

1. Click on File Menu and then select the Options menu. Click Options from the drop down menu to open the Excel options window as follows.

2. Click on Customize ribbon option in the Excel options window. Then on the right side under the list of Main Tabs, click on the "Developer" checkbox and then click on OK.

3. The Developer tab will appear on the default tabs at the top of the Excel window. The tab contains a list of all features that we will need for advanced functions.

Next now we will discuss about the Architecture of VBA.

1. Excel Application - When we install the Excel while downloading the office then the installed Excel is also termed as Excel Application.
2. Workbook - The files which are created and saved which we need to work upon is known as Workbook.
3. WorkSheet - The Sheets which are contained under Excel or Workbook is also referred to as WorkSheet. There can be one worksheet or multiple worksheets under one workbook.
4. Range - Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells or a 3D range. For example, if we want to access range from A2 to C5 then the syntax will be Range("A2:C5").
5. Cells - Cells is a property of a range or worksheet or Application objects. Cells returns a Range object. Cells can be used without any parameter passed or a single parameter passed in it. For example, if we want to refer first row and first column then the syntax would be Cells(1,1).
6. Columns & Rows - The Excel contains a combination of rows and columns and in VBA we can calculate the last row and column in which the data is present which we will discuss in our next discussion.

If you have any queries related to this article you can post your queries in the comment section and i will respond to your queries. Comments and suggestions are always appreciated.