Even and Odd
 

IS there a keyword in Visual Basic that recognizes whether a number is odd or
even.

Even and Odd
 

If you have Analysis Toolpak loaded and set a reference to it in VBA, then
ISODD() and ISEVEN() are available

--
Kind regards,

Niek Otten

"aftamath" wrote in message
...
IS there a keyword in Visual Basic that recognizes whether a number is odd
or
even.

Even and Odd
 

You could 'roll your own'

Function test(num) As Boolean
test = (num Mod 2 = 0)
End Function

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"aftamath" wrote in message
...
IS there a keyword in Visual Basic that recognizes whether a number is odd
or
even.

Even and Odd
 

Could you explain a little more on how to call these functions and an exampl
of code for them. How t oset a reference? Thanks in advance.

"Niek Otten" wrote:

If you have Analysis Toolpak loaded and set a reference to it in VBA, then
ISODD() and ISEVEN() are available

--
Kind regards,

Niek Otten

"aftamath" wrote in message
...
IS there a keyword in Visual Basic that recognizes whether a number is odd
or
even.