Chapter 21
Creating Worksheet Functions
IN THIS CHAPTER
Knowing why custom worksheet functions are useful
Understanding the basics of custom worksheet functions
Writing your own functions
Exploring functions that use various types of arguments
Examining function examples
Working with 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.
Create Custom Functions to Simplify Your Work
You’re undoubtedly familiar with Excel’s worksheet functions; even Excel novices know how to use common worksheet ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access