How to create our own function in excel VBA.

This video helps you to create our own user defined function by using VBA, to solve complex equation in excel instantly.
Here is the example of the variance of the pareto distribution.

STEPS:
1) Enable developer tab (File → Options → Customize Ribbon → Developer)
2) Open VBA project page ( Developer → Visual Basics → Insert → Module)
3) If "option explicit" is not written then write it manually.
4) Identify the variables in equation(in example there are 2 variables α and λ)
5) Write the VBA expression. (refer video)
6) Open spreadsheet and use the new function. (refer video)

Like share and subscribe for more videos.
Comment below if you have any doubts.

Other useful videos
1) Shortcuts of some useful mathematical notations in MS-WORD
2) How to create our own shortcuts of mathematical symbols in MS-WORD