Appendix B. VBA Functions

In this Appendix

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 each VBA function and the arguments it uses (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

image

Table B.2. Date and Time Functions

Table B.3. Error Functions

Table B.4. File and Directory ...

Get Absolute Beginner's Guide to VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.