It's generally more efficient just to use the Mod function:

Const nTest As Long = 42
Dim bIsOdd As Boolean
Dim bIsEven As Boolean
bIsOdd = nTest Mod 2 = 1
bIsEven = nTest Mod 2 = 0
MsgBox "bIsOdd: " & bIsOdd & vbNewLine & "bIsEven: " & bIsEven


In article <162893FB-35BB-4CC9-8758-131E75E35D14@microsoft.com>,
"aftamath" <aftamath@discussions.microsoft.com> wrote:

> IS there a keyword in Visual Basic that recognizes whether a number is odd or
> even.
> Could you explain a little more on how to call these functions and an example
> of code for them. How to set a reference to the Analysis toolpak for
> iseven(), isodd()? Thanks in advance.