Write 11 page essay on the topic Automation Tools.Download file to see previous pages... The pane, labeled 'Classes' (encircled in blue), displays the name of all objects that are contained in the lib

Write 11 page essay on the topic Automation Tools.

The pane, labeled 'Classes' (encircled in blue), displays the name of all objects that are contained in the library, VBA. these objects are called classes, modules and enumerations. These objects have constants, properties and functions, which are listed in pane, labeled 'Members of XXXXX' (encircled in green), through which they define their attributes and set of actions that they can perform. For example, in above figure, it can be noted that there are only two constants, vbModal and vbModaless, are defined in enumeration, FormShowConstant. Also note that the summarized detail for the selected member, vbModaless, is also displayed in the bottom pane (encircled in pink).

Executes code one statement at a time. when not in design mode, Step Into enters break mode at the current line of execution. If the statement is a call to a procedure, the next statement displayed is the first statement in the procedure. At design time, this menu item begins execution and enters break mode before the first line of code is executed.

This option is similar to Step Into. the difference in use occurs when the current statement contains a call to a procedure. It executes the procedure as a unit, and then steps to the next statement in the current procedure. ...

For example, in above figure, it can be noted that there are only two constants, vbModal and vbModaless, are defined in enumeration, FormShowConstant. Also note that the summarized detail for the selected member, vbModaless, is also displayed in the bottom pane (encircled in pink).

Question 1(c):

What debugging facilities are available within the Visual Basic Editor (VBA IDE).Describe how they might be used to debug code

Answer 1(c):

In Visual Basic Editor, all debugging facilities can be accessed through options that are available in 'Debug' menu. this menu contains the following menu items:

1. Step Into

Executes code one statement at a time. when not in design mode, Step Into enters break mode at the current line of execution. If the statement is a call to a procedure, the next statement displayed is the first statement in the procedure. At design time, this menu item begins execution and enters break mode before the first line of code is executed.

If there is no current execution point, the Step Into command may appear to do nothing until something is done that triggers code, for example clicking on a document.

2. Step Over

This option is similar to Step Into. the difference in use occurs when the current statement contains a call to a procedure. It executes the procedure as a unit, and then steps to the next statement in the current procedure. Therefore, the next statement displayed is the next statement in the current procedure regardless of whether the current statement is a call to another procedure. This option is available in break mode only.

3. Step Out

Executes the remaining lines of a function in which the current execution point lies. The next statement displayed is the statement following the procedure call.