A VBA function a function like one that is already in Excel (sum, average, count etc.) which allows you to extend the functionality of Excel.
A function returns a value. So basically you can create your own “sum” function:
Function MySum(arg1, arg2) As Double
Dim dblTemp As Double
dblTemp = arg1 + arg2
MySum = dblTemp
Let me know if you have any questions