Excel VBA Functions

What is VBA function?

Excel VBA functions is a group of reusable code which can be called anywhere in your program. So, this helps us as no need of writing same code again and again. These methods also help the programmer divided their big programs into small and meaningful functions.

What is UDF in excel VBA?

Using VBA coding we can create our own functions and those functions are called “User-Defined Functions” (UDF). They are also known as “custom functions” in excel VBA.

A UDF (User Defined Function) is a group of commands or group of code block written in VBA that accepts inputs from user and returns a result.

A UDF cannot modify the formatting of a cell or workbook or move values around on a worksheet.