Learn Excel VBA function to create user defined function or formula

Title: Learn Excel VBA function to create user defined function or formula

Recommended Excel VBA books
===================================================
====================================================

In this video, you'll learn about how to create and use function procedures in excel VBA

with an example.If you want Excel VBA to perform a task that returns a result, you can use a

function. A UDF (User Defined Function) is simply a function that you create yourself with

VBA. UDFs are often called "Custom Functions". A UDF can remain in a code module attached to a workbook, in which case it will always be available when that workbook is open. UDFs can be accessed by code modules too. Excel VBA function return a value but sub routines do not return a value.

[golferj]

could you let me know the code if the values "a" and "b" are stored in a known cell location in the same row that you are inserting the user defined function?  I would like to automatically reference the cells where "a" and "b" are stored rather than manually typing in these valuesThanks, Jay