Mod Operator
The Mod operator in Excel VBA gives the remainder of a division. Place a command button on your worksheet and add the following code line:
MsgBox 7 Mod 2
Result when you click the command button on the sheet:
7 is divided by 2 (3 times) to give a remainder of 1.
Code line:
MsgBox 8 Mod 2
Result:
8 is divided by 2 (exactly 4 times) to give a remainder of 0.