Using built-in VBA functions
A good starting point for this recipe is a refresher of the definition of a function.
A function performs a calculation and returns a single value. Built-in functions are no different in that respect – the end result will always be a single value.
In this recipe, we will be working with built-in functions exclusively. Given the number of available functions, it is important to understand the principles of built-in functions, rather than trying to understand how each function can be used or applied.
A list of every built-in function would take up too much space, so instead refer to the three links here:
- Functions in alphabetical order: https://bettersolutions.com/vba/functions/complete-list.htm
- Functions grouped by type: https://www.excelfunctions.net/vba-functions.html
- Functions in the VBA Help system: https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/visual-basic-for-applications...