Microsoft Office Tutorials and References
In Depth Information
Create Your Own Functions
Macros and VBA programming can only be saved in Macro-Enabled
Workbook.
After you type in the first line and press Enter, the last one appears
automatically. This example function adds two numbers, and the word
Public lists the function in the Insert Function dialog box. You may have
to find the Excel workbook on the Windows task bar because the Visual
Basic Editor runs as a separate program.
Figure 18-11:
Writing
your own
function.
5.ReturntoExceltofindandusethefunctionintheInsertFunctiondialog
boxintheUserDefinedCategory.ClicktheInsertFunctionbuttonin
the Formulas tab to display the dialog.
Figure 18-12 shows this.
Figure 18-12:
Finding the
function in
the User
Defined
category.
Search JabSto ::




Custom Search