IsNumber (Text As String) As Boolean
Tests whether the specified string can be safely parsed as a number.
To test if it is an integer....
Floor (Number As Double) As Double
Returns the largest double that is smaller or equal to the specified number and is equal to an integer.
ie if X - Floor(X) then ....
BlueJay