Excel VBA

Introduction To VBA: Macros And Automation Part 1

The VBA Editor

Exploring The Editor

With some of the basics keywords covered, we now have enough context on the VBA language to begin exploring the editor and creating our first subroutines. In this section we will navigate to the VBA Editor, and identify its primary components. There is a large overlap between the names used to define the segments of a traditional Excel window, and those used for the VBA Editor.

1. The Title Bar

It shows the name of the current window, and the Excel file name which is currently active. In this section are also the navigation buttons to minimize, toggle fullscreen, and close the editor window.

2. The Menu Bar

Lists all of the menu tabs available, and contains the primary set of tools used to create, modify, and test code.

3. The Quick Access Toolbar

Holds the most frequently used tools such as the save, insert, run, break, and design tools. It can be modified to show or remove additional tools.

4. The Project Window

Displays the list of workbooks, add-in files, and modules which exist in the currently activated files. Users can view the names and object types of all objects within the window.

5. Properties Window

Allows users to see all the modifiable properties of the currently selected object. Properties can be modified directly through this window, and this is where aspects such as module names can be changed.

6. Activity Window

The main window where any open modules or workbooks will be displayed. Windows can be stacked, split, and aligned to the users liking in this workspace. It is where you will be spending the majority of your time while coding.