ActiveX Combo Box Focus

[CraigB]

From MikeF and my comments. I have the same problem:

I am having the same problem and I am totally stumped. I have founds some
code snippets on Debra's site. It looks something like this:

Private Sub TempCombo_KeyDown(ByVal _
KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)
Select Case KeyCode
Case 9 'Tab
ActiveCell.Offset(0, 1).Activate
Case 13 'Enter
ActiveCell.Offset(1, 0).Activate
Case Else
'do nothing
End Select
End Sub

I am getting some really funky results though. I am substituting 'TempCombo'
with one of my activeX combo boxes.....Very rusty on my VB. Tab seems to hop
around, but not where I want it to. Once it has hopped back into excel and I
go back into combo box to delete the contents, it also will just bounce
around....arrgggh!

Thanx.
You're right, the ESC key does work ok.
The range.select code is also ok, if you're only using the drop-down with a
mouse.
Using word-search with the keyboard, it jumps immediately to the designated
cell after the first letter typed.

Again, ideally would like to assign the tab key to it, and just "tab off"
after making the selection, but perhaps that is not possible.

- Mike

Thanks in advance