Enter after selection in combo box

[Marta B]

I'm new here and with the Developer tab, so I apologize if this is a simple issue.
I inserted a ComboBox pulling a list from a different tab. It functions and auto completes the selection (which is what I was trying to attain), but then I can't enter or tab out of the box to move to the next cell. Do I need to set something in the Properties?

 

[6StringJazzer]

It sounds like you have your combobox on a worksheet (not a UserForm). Comboboxes are not like cells. You can't hit ENTER or tab out of it. You have to click on the next cell.

It is possible to add code that will take you to a specific cell when you change the value in a combobox

Private Sub ComboBox1_Change()
   Range("A1").Select
End Sub

 

[Akuini]

but then I can't enter or tab out of the box to move to the next cell. Do I need to set something in the Properties?

Put this code in the sheet code module:

Private Sub ComboBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    If KeyCode = vbKeyReturn Or KeyCode = vbKeyTab Then
            Range("C1").Activate  'change to suit
    End If
End Sub