You could lookup the value of the onchange event and change it to the
combobox:
----------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Select Case Target.Address
Case Is = "$B$2"
ComboBox1.Activate
Case Is = "$B$4"
ComboBox2.Activate
End Select

End Sub
----------------------------------------
Adjust the ranges and the ComboBox-names. If there are a lot of
comboboxes it'll be a little complex.

This code has to be inserted in the Worksheet module you want the code
to work. To do that, right click on the Worksheet-tab and click "View
Code..."

hth

Carlo

On Dec 10, 4:35 pm, Pam wrote:
I have a worksheet with several combo boxes and the work great as far as
typing in the first letter and it auto completing.
My problem is, many of our users want to "tab" to the next field, and they
get in the field, but they don't actually select the combo box until they
mouse click on it.
Is there some way I can set this so that they can tab to it and actually
select the combobox instead of the cell behind it?
Thanks for any help you can give me