title: Excel VBA If Condition
body: <p>For some reason the i'm running everytime into the condition even when it doesn't verifies.</p>
  
  <pre><code>If CC = "63165-POLIMENTO" And Format(registos.TextBox4, "#") &lt; 0 Or Format(registos.TextBox4, "#") &gt; ThisWorkbook.Worksheets("calculos2").Range("B4") Then
  </code></pre>
  
  <p>My problem is on greater and less operators , i believe they are misplaced.</p>