Chapter 10: Creating Function Procedures


image from book  Download CD Content

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.




Excel 2007 Power Programming with VBA
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
ISBN: 0470044012
EAN: 2147483647
Year: 2007
Pages: 319

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net