Microsoft Excel has lot of built in formulas like Sin(), Avg() and many more, which we discuss in detail in future articles, but apart from that you can write your own functions which will act as any other built-in formula in excel , Which is one of the powerful feature of Excel.

Like other formulas, you can apply your function in each cell or range of cells.

**Syntax:**

**Public Function functionName (Arg As dataType,……….) As dataType**

**or**

**Private Function functionName (Arg As dataType,……….) As dataType**

**Arg As dataType -> data type of argument**

**The second data type is the return type of function.**

**Public : **The function is applicable to the whole project.

Read moreVBA-Excel: User Define Functions