Automation Tools Math Problem Example | Topics and Well Written Essays - 2750 words

Automation Tools - Math occupation ExampleThe pane, labeled Classes (encircled in blue), displays the name of all objects that argon 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 keep perform. For example, in above figure, it female genitals be noted that there are simply two constants, vbModal and vbModaless, are defined in enumeration, FormShowConstant. to a fault note that the summarized detail for the selected member, vbModaless, is also displayed in the hindquarters pane (encircled in pink).Executes code one record at a time when not in design mode, stones throw Into enters pass on mode at the incumbent line of execution. If the program line is a call to a procedure, the coterminous account displayed is the runner teaching 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 metre Into the difference in use occurs when the current tilt 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 powerfulness be used to debug codeAnswer 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 items1. yard IntoExecutes code one statement at a time when not in design mode, grade 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 tonus Into command may appear to do nothing until something is done that triggers code, for example clicking on a document. 2. Step OverThis 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 OutExecutes the remaining lines of a function in which th e current execution point lies. The next statement displayed is the statement following the procedure call. All of the code is executed