title: VBA If Statement within For (Else Running even when If condition is met)
body: <p>I'm pretty new to VBA and having issues with a Else statements running even when If conditions are met.</p>
  
  <p>Pretty sure this is due to the If statement being within a For &amp; Next</p>
  
  <pre><code>For iCnt = 1 To Len(Firstname)
      If IsNumeric(Mid(Firstname, iCnt, 1)) Then
          MsgBox "The Firstname cannot contain Numeric values"
      ElseIf Len(Firstname) &gt; 100 Then
          MsgBox "The Firstname exceeds the character limit (100)"
      Else
          Sheet3.Cells(lRow, 2).Value = Me.Firstname.Value
      End If
  Next iCnt
  </code></pre>
  
  <p>Please any suggestions how to fix this?</p>