Whole number

[MagicalDean]

I'm sure this is really simple, but how do I get VBA to check if a number is a whole number? Its probably really simple but I can't see how to do it Any help is greatly apprechiated

 

[BUDBDL]

If the number is the same as it's integer and greater than zero, isn't it a whole number ?

if MYNUMBER >= 0 and int(MYNUMBER) = MYNUMBER then msgbox "I AM WHOLE"

 

[traingamer]

You don't even need the >=0 check - the rest of the statement is enough.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[MagicalDean]

Aha, thanks guys Much apprechiated!