I am currently working on an Excel VBA project that requires me to check if the number obtained by Excel is an even number, or if it is an odd number.

I accomplished this using the Mod operator. The Mod (modulus) operator is the VBA equivalent to the MOD function in Excel. It’s purpose is to find the remainder after a number has been divided by a divisor.

The Mod operator is written as below where *a* and *b* represent variables containing values;

aModb

If *a* stored the value 20 and *b* stored 6 then the result would be 2. And if *a* stored 20 and *b* stored 4 then the result would be 0.

To check if a value is an even or an odd number I used the Mod operator to divide the variable holding the number by 2. If the result returned 0 then it must be an even number. And if not then it must be an odd.

The end result was to use an If… Then… Else conditional statement to take action on the answer from the Mod operator. This looked like the below;

IfaMod 2 = 0 thenThe number is even, do somethingElseThe number is odd, do something elseEnd If

dinesh Pal says

gr8 site for excel vba

rice pot says

Thanks a lot! This really helped. 🙂

David says

I’ve been working on an assignment for over two hours and this answer helped me solve the problem in 2 minutes. Thanks so much!

Alan Murray says

Brilliant! Happy to help, David.