Home / MS-Excel / General Formatting

VBA Functions

VBA boasts more than 160 built-in functions that cover data conversion, dates and times, math, strings, and much more.

This appendix presents a categorical list of VBA functions and the arguments they use (required arguments are shown in bold type).

You can get full explanations and examples for all the functions in the Functions section of the VBA Help file.

Following these sections:

  • Conversion Functions
  • VBA Date and Time Functions
  • Error Functions
  • File and Directory Functions
  • Financial Functions
  • Math Functions
  • Miscellaneous Functions
  • String Functions

In this tutorial:

  1. Conversion Functions
  2. VBA Date and Time Functions
  3. Error Functions
  4. File and Directory Functions
  5. Financial Functions
  6. Math Functions
  7. Miscellaneous Functions
  8. String Functions