Writing functions
Writing a function is similar to writing a procedure, in the sense that both are created in the VBA Editor. That is where the similarities end, though.
Apart from the fact that functions only return values, and cannot be executed independently like Sub procedures, there is also a difference in structure, headings, code structure, and then the all-important arguments.
Once you understand these principles, creating your own functions will become an important part of your VBA journey.
In this recipe, we will be creating and writing several functions.
Getting ready
Open Excel and activate a new workbook. Save the file as a macro-enabled file on your desktop and call it CustomFunctions.xlsm. Sheet1 should be active. Press Alt + F11 to switch to the VBA Editor, then insert a new module.
How to do it…
Here is how to write a function:
- As in so many other cases in the Microsoft environment, there is more than one way of achieving the same...