Functions in Excel VBA

The main purpose of is to help you work with functions 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 the first two types of functions above. UDFs are covered (in detail) in .

As you learn in :

• Functions play an important role in VBA.
• Working with functions in VBA has, to a certain extent, important similarities with working with functions in regular Excel.

Your pre-existing knowledge about Excel continues to be useful as you learn how to work with functions in VBA. There are some specific considerations that apply when you work with functions in VBA.

:

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

is divided into five Chapters.

• Chapter 1 is an introduction to working with functions in VBA.
• In Chapter 2, you learn how to work with VBA built-in functions.
• Chapter 3 contains several examples to help you practice working with VBA built-in functions.
• In Chapter 4, you learn how to work with Excel worksheet functions in VBA.
• Chapter 5 contains several examples to help you practice working with Excel worksheet functions in VBA.