Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
Overview
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. |