title: VBA Userform Set Focus Issue
body: <p>I have an issue that's been bugging me for a few hours now:</p>
  
  <p>I have a Clear Button on my Excel userform runs a subroutine that clears all data in my XY Frame.</p>
  
  <p>After running this, I want to return the focus to a textbox in the XY Frame.  However, I get an error every time I try to use .SetFocus.</p>
  
  <p>While messing with this, I figured out that the "ActiveControl" is still the Clear Button, and I'm wondering how to switch the ActiveControl to my XY Frame.  XYFrame.Activate doesn't work.</p>
  
  <p>Any ideas?</p>
  
  <pre><code>Private Sub ClearButton_Click()
  
      ClearForm ' Run subroutine to clear out data
  
      MsgBox (XYForm.ActiveControl) ' This shows that ActiveControl is still "ClearButton"
      XYFrame.Activate ' This gives an error
      XYFrame.TextBox1.SetFocus ' This gives an error
  
  End Sub
  </code></pre>
  
  <p>The other maddening thing is that I can refer to the textbox value without any issues, but I just can't SetFocus on the textbox either in the subroutine or in the ClearButton sub.</p>
  
  <pre><code> XYForm.TextBox1.Visible = True  'works fine                        
   XYForm.TextBox1.Enabled = True  'works fine
   XYForm.TextBox1.Locked = False  'works fine
   msgbox(XYForm.TextBox1.Value)   'works fine
   XYForm.TextBox.SetFocus         'doesn't work
  </code></pre>