O'Reilly logo

Excel VBA Programming For Dummies, 5th Edition by John Walkenbach, Michael Alexander

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 20

Creating Worksheet Functions — and Living to Tell about It

IN THIS CHAPTER

Bullet Knowing why custom worksheet functions are so useful

Bullet Understanding the basics of custom worksheet functions

Bullet Writing your own functions

Bullet Exploring functions that use various types of arguments

Bullet Examining function examples

Bullet 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). Chapter 5 introduces the concept of custom functions. In this chapter, you take a deeper dive with some real-world examples.

Why Create Custom Functions?

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required