July 2019
Beginner to intermediate
944 pages
27h 45m
English
VBA comes with a large number of built-in functions that perform commonly needed operations—everything from determining whether a file exists on the hard drive to returning the current date or converting data from one format to another. For example, there's a function that converts numeric data into a text string.
In this book, I usually refer to most VBA language components (VBA's diction) as commands. In this chapter, though, we'll call them functions. Other names that are sometimes used—more or less accurately—for these built-in commands include: operations, methods (with objects), routines, procedures, and stored procedures.
This chapter demonstrates what functions are, what they do, and how to use them. ...