Modules :
Modules is the area where the code is written. This is a new Workbook, hence there aren't any Modules.

To insert a Module, navigate to Insert → Module. Once a module is inserted 'module1' is created.
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.

Procedure
Procedures are a group of statements executed as a whole, which instructs Excel how to perform a specific task. The task performed can be a very simple or a very complicated task. However, it is a good practice to break down complicated procedures into smaller ones.
Visit : http://www.tutorialspoint.com/
No comments:
Post a Comment