Functions, unlike Sub procedures, can be executed in only two ways:
i By calling the function from another Sub procedure or Function procedure i By using the function in a worksheet formula
Try this simple function. Enter it into a VBA module:
CubeRoot = number A (1/3) End Function
This function is pretty wimpy — it merely calculates the cube root of the number passed to it as its argument. It does, however, provide a starting point for understanding functions. It also illustrates an important concept about functions: how to return the value that makes functions so important. (You remember that functions return values, right?)
Notice that the single line of code that makes up this Function procedure is a formula. The result of the math (number to the power of 1/3) is assigned to the variable CubeRoot. Notice that Squared CubeRoot is the function name, as well. To tell the function what value to return, you assign that value to the name of the function.
Was this article helpful?