title: Set focus on UserForm Textbox on tabbing from another Textbox
body: <p>I have a Userform in Excel. It has 6 Textboxes, they are the only controls on the Userform with TabStop set to True. </p>
  
  <p>I can tab and move through the textboxes. I cannot get <code>SetFocus</code> to work on Events fired when moving between the Textboxes. I can put a CommandButton on the userform with <code>Userform16.Textbox1.Setfocus</code> and it works as expected to move the focus to Textbox1.</p>
  
  <p>I set up a simple test event (see below) to move the textbox focus back up to TextBox1 when Textbox2 is entered. It moves focus to Textbox3 when I tab out of TextBox1.</p>
  
  <pre><code>Private Sub TextBox2_Enter()
     Cancel = True
     UserForm16.TextBox1.SetFocus
  End Sub
  </code></pre>
  
  <p>By putting a <code>Stop</code> in the above, I can see that the event is firing as expected, but it will not allow me to control the focus the next control.</p>
  
  <p>I get the same results with or without the <code>Cancel = True</code> statement in the sub.</p>