Chapter 3. VBA Variables and Data Types

The VBA language offers a full set of the usual data types, plus a smart data type called a Variant, which is the chameleon of the programming world, adapting itself seamlessly to hold any type of data. This chapter lists the data types available in VBA and discusses a complete range of issues related to data types, including variable scope and lifetime, the character of the variant, and performance issues that arise in using particular data types.

Get VB & VBA in a Nutshell: The Language 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.