Numeric expressions
A numeric expression is one that…, er, gives you a number.
Here's a numeric expression:
3 - ( aVariable / anotherVariable ^ 2 + 4) * Sqr( yetAnother + 13 )
It has variables (aVariable
, anotherVariable
, and yetAnother
), constants (3, 2, 4, and 13), operators (-, (), /, ^, +, and *), and a function (Sqr()
, that calculates square root).
Numeric data types
Each variable has a data type. The data type limits what data you can put into the variable. VBA has about half-a-dozen numeric data types.