Using VBA is a combination of utilising libraries available, mainly Excel and VBA. The following list of functions is a selection of commonly used functions, which. The following table provides a list of commonly used VBA statements that you might use when creating macros for VBA Functions for Excel VBA Programming. Learn how to use all Excel VBA functions used in Macros. Here are the VBA Below is a list of Excel VBA functions sorted alphabetically. If you would like a list InStr() · MID · Formulas and Functions · Left.