VBA also has a large set of built-in functions and procedures, the use of which greatly simplifies programming. Like worksheet functions, the functions available in VBA can be divided into several main categories.
It should be noted that all the necessary information related to the use of available functions can be found in the VBA Help system:
- Open the Visual Basic for Applications editor window and select the command Help | Visual Basic for Applications Help (or press the F1 key).
- In the Excel Help window, select in the table of contents on the left: Visual Basic for Applications Language Reference | Visual Basic Language Reference | Functions.
From there, you can see the full list of VBA functions and examples of their use.