More on Visual Basic Editor or VBE

Although we already about the how to record a macro let us familiarize ourselves with the Visual Basic Editor Window.

Below is the snapshot of the VBE and its components:

Snapshot of VBE Window

I do not want to provide further explanation regarding these feature as they are quite self-explanatory. The idea is to familiarize you with the notations that I shall be using henceforth to refer to any of these components. Also, note that there is a feature called “Immediate Window”, it can be activated by pressing Ctrl+G together. The usage is related to debugging the code. We shall understand its role later.