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 VBA uses numeric values in some way. For optimal performance and efficiency, and for accuracy in calculations, it's important to understand the different numeric data types and when to use which.