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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.