User Defined Function - Comprehensive Tutorial - Create Your Own Excel Functions using VBA

In this video, you'll learn how to create your own custom function (user defined function or udf) in Excel using VBA. A User Defined Function (UDF) is a function that you create with arguments you specify, to use as a worksheet function or as part of a macro procedure, when a task is otherwise impossible or too cumbersome to achieve with Excel’s built-in formulas and functions We'll explore: 00:00 Introduction 00:09 Customize Quick Access Toolbar to Add Visual Basic Editor 00:37 Anatomy of UDF - A very basic function 01:28 Declare Arguments 03:08 Declare Optional Arguments 05:00 Skip Optional Arguments 05:45 Control the output of UDF 06:36 VBA Data Types 06:51 Declare data types to prevent errors and improves the performance 09:07 Create static random number function 09:36 Volatile vs. non-volatile function 11:47 How to make your function Volatile