Page 34 - Excel for Scientists and Engineers: Numerical Methods

CHAPTER 1 INTRODUCING VISUAL BASIC FOR APPLICATIONS 11

typing it (Figure 1-14). When you press enter, the result calculated by the
function appears in the cell (Figure 1 - 15).

Figure 1-14. Entering the custom function.

Figure 1-15. The function result.

You can also enter a function by using the Insert Function dialog box. Select
the worksheet cell or the point in a worksheet formula where you want to enter
the function, in this example cell B2. Choose Function.. . from the Insert menu
or press the Insert Function toolbutton to display the Insert Function dialog
box. Scroll through the Function Category list and select the User Defined
category. The FtoC function will appear in the Insert Function list box (Figure
1-16).

Figure 1-16. The Paste Function dialog box.
When you press OK, the Function Arguments dialog box (Figure 1-17) will be
displayed. Enter the argument, or click on the cell containing the argument to
enter the reference (cell A2 in Figure 1-14), then press the OK button.