title: ComboBox open on mouse over event and close after mouse moves off it - in Excel VBA
body: <p>Idea is to have a ComboBox open - when mouse cursor moves over it, without having to click on it, and when mouse moves off it for it to close back down.</p>
  <p>Code below seem to be opening it, but with caveats:</p>
  <p>a) code keeps firing the Alt + Arrow Down while you are thinking what list item to pick - want it to do it just to open the ComboBox and then stop,</p>
  <p>b) once you pick the item, it fires Alt + Arrow Down on a new active cell, which is not the intent. And that new cell prevents ComboBox from opening on the next mouse over.
  (*I also have another code, which once list item is picked is finding and selecting corresponding cell in A column)</p>
  <pre><code>Private Sub ComboBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
      ComboBox1.Activate
      SendKeys &quot;%{DOWN}&quot;
  End Sub
  </code></pre>