CHAPTER 5
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 vs. Function Procedures

A VBA Function is a procedure that performs calculations and returns a value. You can use these functions in your Visual Basic for Applications (VBA) code or in worksheet 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...