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 ,
"aftamath" 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.