title: Re-Focusing on an Excel Userform ComboBox
body: <p>A User is Entering Data into the Edit Region of a ComboBox</p>
  
  <p>The ComboBox's Change Event is used to run the following Code;</p>
  
  <pre><code>    AppActivate "Microsoft Excel"
          :
      'Do some stuff
          :
      UserForm1.Show
      UserForm1.ComboBox1.SetFocus
  </code></pre>
  
  <p>This works OK, BUT; even though the ComboBox now has the Focus again (according to the Userform.ActiveControl anyway), it has no Insertion Pointer to indicate this fact, and the User has to Re-Select the ComboBox before he can continue entering Data</p>
  
  <p>I would like to have it so that the Insertion Pointer reappears and the User can continue Entering Data directly, without having to Re-Select the ComboBox</p>
  
  <p>Adding the following line of Code</p>
  
  <pre><code>    SendKeys "{TAB}+{TAB}{RIGHT}"
  </code></pre>
  
  <p>is one solution, but it is messy (it generates ComboBox Events and using SendKeys is best avoided if possible anyway)</p>
  
  <p>Can anyone suggest a better solution?</p>
  
  <p>Q. Why do black sheep eat less than white sheep?</p>
  
  <p>A. Because there aren't as many of them</p>