title: VBA: How to determine whether the number is Integer, even if it's received as a Double initially, let's say 3.0?
body: <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>