Numeric

VBA provides several different numeric data types, depending upon the type of numeric value you want to save.

VBA provides three different integer data types. Integers are numeric values that do not include a decimal portion of the value. VBA uses three different types of floatingpoint data. The one you select depends upon the size of the numeric values you want to store in the variable. The following table lists VBA floating-point values:

DATA TYPE

BYTES

RANGE OF VALUES

Single

4

-3.402823E38 to -1.401298E-45 for negative values

1.401298E-45 to 3.40283E38 for positive values

Double

8

-1.79769313486232E308 to -4.94065645841247E-324 for negative values

4.94065645841247E-324 to 1.79769313486232E308 for positive values

Currency

8-922,337,203,685,477.5808 to 922,337,203,685,477.5807

0 0

Post a comment