Chapter 20

Creating Worksheet Functions — and Living to Tell about It

In This Chapter

arrow Knowing why custom worksheet functions are so useful

arrow Understanding the basics of custom worksheet functions

arrow Writing your own functions

arrow Exploring functions that use various types of arguments

arrow Examining function examples

arrow Understanding the Insert Function dialog box

For many macro mavens, VBA’s main attraction is the capability to create custom worksheet functions — functions that look, work, and feel just like those that Microsoft built into Excel. A custom function offers the added advantage of working exactly how you want it to (because you wrote it). I introduce custom functions in Chapter 5. In this chapter, I get down to the nitty-gritty and describe some tricks of the trade.

Why Create Custom Functions?

You are undoubtedly familiar with Excel’s worksheet functions; even Excel novices know how ...

Get Excel VBA Programming For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.