Working with Numbers

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Almost every procedure you write in Microsoft® Visual Basic® for Applications (VBA) uses numeric values in some way. For optimal performance and efficiency, and for accuracy in calculations, it is important to understand the different numeric data types and when to use which.

In This Section

  • Getting the Most Out of Visual Basic for Applications
    Write code that is fast, efficient, easy to read and maintain, and, if possible, reusable with a solid working knowledge of Microsoft® Visual Basic® for Applications (VBA) — what features the language includes and what you can do with it.
  • Working with Strings
    Understand how to get information from strings.
  • Working with Dates and Times
    Manipulate date values in Microsoft® Visual Basic® for Applications (VBA), and understand how VBA stores date values internally.
  • Working with Files
    Understand the Microsoft Scripting Runtime object library, and work with drives, folders, and files as objects.
  • Understanding Arrays
    Use arrays when you must store a number of values of the same type, but you do not want to create individual variables to store them all.
  • Tips for Defining Procedures in VBA
    Define a Function or Sub procedure, and use the options available to you to make your code more extensible or more flexible.
  • Optimizing VBA Code
    Understand how to streamline your Microsoft® Visual Basic® for Applications (VBA) code to streamline your memory requirements.