title: Populate a textbox based on the value of another textbox
body: <p>I believe the issue is that Val(txtspark) is not recognized as a number.</p>
  <pre><code>Private Sub txtSpark_Change()
  
      If Len(txtSpark.Text) = txtSpark.MaxLength Then
          txtNote.SetFocus
      End If
     
      If Val(txtSpark) &lt; 90 Then
          txtNote.Text = &quot;Refill Required&quot;
      End If
     
  End Sub
  </code></pre>