Check for Integer?

  • Thread starter Thread starter garyh
  • Start date Start date
G

garyh

Does anyone know of a way to easily check numeric data to
determine if it is an integer? There are a number of IS*
functions (IS NULL, et al.), but I can't seem to find a
way to easily check.

Any help is welcome. Thanks.

Gary
 
Does anyone know of a way to easily check numeric data to
determine if it is an integer? There are a number of IS*
functions (IS NULL, et al.), but I can't seem to find a
way to easily check.
Click to expand...

If you know the data is numeric, then all you need is to
check if it matches it integer part.

If x = Int(x) Then
' it's an integer
Else
' not an integer
End If

If you want, you can create your own function based on the
above logic:

Public Function IsInteger(x As Variant) As Variant
IsInteger = (x = Int(x))
End Function
 
R. Hicks said:
Use the IsNumeric() Function ...
Click to expand...

You've said that twice now and I still don't see how
IsNumeric can be used to determine if a number is an
integer. It's not even clear if IsNumeric tells you when a
string is a number (e.g. IsNumeric("3D4-") is True) so I
would appreciate it if you would elaborate on how to apply
your suggestion to the question.
 
Back
Top