User-Defined Functions (UDFs) in Excel VBA

The main purpose of is to help you work with User-Defined Functions (UDFs) in Excel VBA. You can work with three types of functions in VBA:

• VBA built-in (or intrinsic) functions.
• Excel worksheet functions.
• User-Defined Functions (UDFs).

focuses on UDFs. VBA built-in functions and Excel worksheet functions are covered (in detail) in .

As you learn in :

• Working with UDFs has several advantages; and
• UDFs play an important role in VBA.

When you work with VBA, you are likely to often create (and work with) UDFs.

:

• Is part of my Book Series; and
  
• Assumes you know about the topics covered in: (i) My previous Book Series, particularly the Book Series; and (ii) The previous Books in the Book Series, particularly , , , and .
  

is divided into five Chapters.

• Chapter 1 is an introduction to User-Defined Functions (UDFs).
• In Chapter 2, you learn how to create UDFs.
• In Chapter 3, you learn how to call UDFs.
• In Chapter 4, you learn how to customize UDFs.
• Chapter 5 contains several examples to help you practice creating UDFs.