Microsoft Office Tutorials and References
In Depth Information
Chapter 10: Creating Function Procedures
10
Creating Function Procedures
In This Chapter
Understanding the difference between Sub procedures and Function procedures
Creating custom functions
Looking at Function procedures and function arguments
Creating a function that emulates Excel’s SUM function
Using functions that enable you to work with pre-1900 dates in your worksheets
Debugging functions, dealing with the Insert Function dialog box, and using add-ins to
store custom functions
Calling the Windows Application Programming Interface (API) to perform otherwise
impossible feats
Sub Procedures versus Function Procedures
A function is a VBA procedure that performs calculations and returns a value. You can use these
functions in your Visual Basic for Applications (VBA) code or in formulas.
VBA enables you to create Sub procedures and Function procedures. You can think of a Sub
procedure as a command that either the user or another procedure can execute. Function
procedures, on the other hand, usually return a single value (or an array), just like Excel worksheet
functions and VBA built-in functions. As with built-in functions, your Function procedures can
use arguments.
Function procedures are quite versatile, and you can use them in two situations:
h As part of an expression in a VBA procedure
h In formulas that you create in a worksheet
 
Search JabSto ::




Custom Search