User`s guide

Understanding the Function Viewer
Understanding the Function V iewer
The Function Viewer controls the execution of worksheet functions. Use the
Function Viewer to organize the list of all currently loaded Excel Builder
functions.
Using the Function V i ewer
The Function Viewer displays the names of all loaded functions. You can e dit
this name to provide a more descriptive identifier. A check box for each entry
denotes the active/inactive state of each function. Inactive functions are not
executed when you click Execute.
Below the function list is a GROUP of eight buttons. To add a new component
to the list of loaded worksheet function s, click New (see “Component Browser”
on page 4-7).
Each of the other buttons performs a specific action on the currently selected
function. To select a function, left-click the list item. The row becomes
selected. You can change the current selection by left-clicking a different list
item, or by using the up and down arrow key s on your key bo ard.
Loading and Executing Functions
To load and execute an Excel Builder function in your worksheet requires
three steps:
1 Load an Excel Builder component.
Click New ontheFunctionViewertodisplaytheComponent Browser.
(See “Compone nt Browser” on page 4-7.) Use this browser to s ele ct the
component you want to load from the list of all currently installed Excel
Builder c omponents. From the sele c ted component, add the method that
you want to call.
2 Set the inp
uts, outputs, and other properties of your function.
Click Edit to display the Function Properties dialog box. (See “Function
Properties” on page 4-8.)
4-5