odd or even number

[Maileen]

Hi,

In my form, i need to find if a number is odd or even.
How can i do it ?

ISODD or ISEVEN are only function from worksheet, but in my case, the
number that i have to test is the row of my listview.
so a simple INT variable.
thanks a lot.
Maileen

 

[Bob Phillips]

Maileen ,

(myInt MOD 2) = 1 gives true for an odd number, false for an even

 

[Ron de Bruin]

Hi Maileen
You can use Mod in VBA

Sub test()
If ActiveCell.Value Mod 2 = 0 Then
MsgBox "Even"
Else
MsgBox "odd"
End If
End Sub

 

[Maileen]

thanksa lot.
it works great.