Microsoft Office 2000/Visual Basic Programmer's Guide   

Working with Numbers

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.