VBA: How to determine whether the number is Integer, even if it's received as a Double initially, let's say 3.0?
<p>My <code>isInteger</code> boolean should be able to resolve into the following boolean values:</p>

<pre><code>2   --&gt; True
3.0 --&gt; True
2.3 --&gt; False
2.9 --&gt; False
4.0 --&gt; True
5   --&gt; True
</code></pre>

<p>I tried to use the following code:</p>

<pre><code>Dim isInteger as Boolean
isInteger = (myNumber Mod 1 = 0)
Debug.Print (isInteger) 
</code></pre>

<p>However the output is always <code>True</code> even when <code>myNumber</code> is 2.3, 3.4, etc.</p>

<p>How should I fix this?</p>