Updating spreadsheet values using functions vba
4 Range Object: The Range object, which is the representation of a cell (or cells) on your worksheet, is the most important object of Excel VBA.
5 Variables: This chapter teaches you how to declare, initialize and display a variable in Excel VBA.
You can do the same thing with a formula as well (as shown in this tutorial), but that becomes complicated and hard to understand.
With this UDF, you only need to pass one argument and you get the result.
8 Macro Errors: This chapter teaches you how to deal with macro errors in Excel.
16 Userform: This chapter teaches you how to create an Excel VBA Userform.
With VBA, you can create a custom Function (also called a User Defined Function) that can be used in the worksheets just like regular functions.
These are helpful when the existing Excel functions are not enough.
In such cases, you can create your own custom User Defined Function (UDF) to cater to your specific needs.