Monday, December 10, 2018

What is Excel Terms?

Modules : 

Modules is the area where the code is written. This is a new Workbook, hence there aren't any Modules.
Module in VBScript
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.
Module in VBScript

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