Business Solutions VBA for the 2007 Microsoft Office System

Appendix B. VBA Functions

Although I discussed quite a few VBA functions in this book, my coverage was by no means exhaustive. 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.

Table B.1. Conversion Functions

Table B.2. Date and Time Functions

Table B.3. Error Functions

Table B.4. File and Directory Functions

Table ...