Used to divide two numbers and return only the remainder.
Syntax
result = number1 Mod number2
The Mod operator syntax has these parts:
Part 
Description 
result 
Required; any numeric variable. 
number1 
Required; any numeric expression. 
number2 
Required; any numeric expression. 
Remarks
The modulus, or remainder, operator divides number1 by number2 (rounding floatingpoint numbers to integers) and returns only the remainder as result. For example, in the following expression, A (result) equals 5.
Usually, the data type of result is a Byte, Byte variant, Integer, Integer variant, Long, or Variant containing a Long, regardless of whether or not result is a whole number. Any fractional portion is truncated. However, if any expression is Null, result is Null. Any expression that is Empty is treated as 0.
Example
This example uses the Mod operator to divide two numbers and return only the remainder. If either number is a floatingpoint number, it is first rounded to an integer.
Dim MyResult
MyResult = 10 Mod 5 ' Returns 0.
MyResult = 10 Mod 3 ' Returns 1.
MyResult = 12 Mod 4.3 ' Returns 0.
MyResult = 12.6 Mod 5 ' Returns 3.

ofm