User-Defined Functions (UDFs) in Excel VBA

By

Power Spreadsheets

The main purpose of User-Defined Functions (UDFs) in Excel VBA 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).

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

As you learn in User-Defined Functions (UDFs) in Excel VBA:

• 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.

User-Defined Functions (UDFs) in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
  
• Assumes you know about the topics covered in: (i) My previous Book Series, particularly the Excel Macros for Beginners Book Series; and (ii) The previous Books in the VBA Fundamentals Book Series, particularly Introduction to Excel VBA Procedures and Sub Procedures, Variables, Data Types and User-Defined Constants in Excel VBA, Procedure Calling in Excel VBA, and Functions in Excel VBA.
  

User-Defined Functions (UDFs) in Excel VBA 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.