Chapter 9Using Built-In Functions
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. ...
Get Mastering VBA for Microsoft Office 365, 2019th Edition 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.