I know there is a way to tell if a value is even or odd, but cannot find it. I have a function that does a count and returns an integer. I just need to determine if that integer is even or odd.
Thanks for the help!!
Troy
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » Determining if a number is even (Word 2007)
You can use the Mod operator for this. Let’s say that you have a variable intCount.
If intCount Mod 2 = 0 Then
MsgBox “The count is even”
Else
MsgBox “The count is odd”
End If
Explanation: a Mod b returns the remainder of a after integer division by b. So for example, 18 mod 7 is 4, because 7 goes 2 times into 18, leaving a remainder of 4. And 15 mod 3 is 0, because 3 goes exactly 5 times into 15, leaving no remainder.
A number mod 2 can be either 0, indicating that the number is divisible by 2 (i.e. the number is even), or it can be 1, indicating that dividing by 2 leaves a reminder (i.e. the number is odd).
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.
Notifications