Exel VBA Solutions

In this chapter, you will spot yourself with the commonly used excel VBA terminologies. These terminologies will be used in further modules, hence understanding each one of these is important.


Modules provide you space to read/write/edit/delete/execute and debut your code.

To insert a Module, navigate to Insert → Module.


Once a module is inserted ‘module1’ is created as shown below.

Within the modules, we can write VBA code and the code is written within a Procedure. A Procedure/Sub Procedure is a series of VBA statements instructing what to do.