title: TextBox SetFocus not working on VBA Form Excel
body: <p>I have simple form which i am planning to use on audit the sorting station at my work. Its pretty simple and looks like this:</p>
  
  <p>.</p>
  
  <p>The Problem: I'm using a handheld scanner (Symbol LI4278) to scan bar codes of every SKU contained in a certain bulk. The procedure is simple:</p>
  
  <ol>
  <li>Scan the bulk Code (Label: Etiqueta de Bulto)</li>
  <li>Then, the focus drops on SKU text Label</li>
  <li>Scan every SKU Barcode</li>
  <li>Send information to an access data base.</li>
  </ol>
  
  <p>My problem lies in that after i scan a SKU Barcode, focus does not return to text label (T4) in order to keep scanning (SKU TEXT LABEL = T4), unless i hit TAB once. I need this to be automatic, and setfocus property is not working.</p>
  
  <p>Here's my code:</p>
  
  <pre><code>Private Sub txtSKU_Change()
  
              Application.EnableEvents = False
              txtBulto.Locked = True
  
              If Len(Me.txtSKU.Value) = 13 Then
  
                  Me.L1.ColumnCount = 3
                  Me.L1.AddItem Me.txtBulto.Value
                  Me.L1.List(L1.ListCount - 1, 1) = Me.txtSKU.Value
                  Me.L1.List(L1.ListCount - 1, 2) = Me.txtAuditor2.Value
                  End If
  
                txtSKU.SetFocus  
              Application.EnableEvents = True
       End Sub
  </code></pre>
  
  <p>I would really appreciate your help on this. I need this application to work perfect for operation purposes and reduce mistakes.</p>
  
  <p>Regards</p>
  
  <p><a href="https://i.stack.imgur.com/ESbdp.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ESbdp.jpg" alt="enter image description here"></a></p>