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- Chapter 11 has many useful and practical examples of Function procedures.

REFERENCE You can incorporate many of these techniques into your work.



0 0

Post a comment