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.