In This Chapter
A function is a VBA procedure that performs some calculations and returns a value. You can use these functions in your Visual Basic for Applications (VBA) code or in formulas.
The difference between Sub procedures and Function procedures
How to create custom functions
About Function procedures and function arguments
How to create a function that emulates Excel's SUM function
How to debug functions, deal with the Insert Function dialog box, and use add-ins to store custom functions
How to call the Windows Application Programming Interface (API) to perform otherwise impossible feats
VBA enables you to create Sub procedures and Function procedures. I cover Sub procedures in the preceding chapter, and in this chapter I discuss Function procedures.
CROSS-REFERENCE | Chapter 11 has many useful and practical examples of Function procedures. You can incorporate many of these techniques into your work. |