TextBox_AfterUpdate acting strange

[Exceladd1ct]

I am trying to set focus and activate the dropdown of a combobox in the After_Update Subroutine of a Textbox. After filling in some text, if i move focus away from the textbox by mouse click, it works fine, if i move the focus away by pressing enter key, it jumps to the 3rd textbox instead of combobox.

I managed to do the job with KeyDown event but, what am i missing? why does it jump to txtbox3 when pressing enter key?

Private Sub TextBox1_afterupdate()
Call combo
End Sub

'Without this, it won't work
Private Sub textbox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    If KeyCode = 13 Then
        If TextBox1.Value <> "" Then
            combo
        Exit Sub
    End If
    End If
End Sub

Function combo()
UserForm4.ComboBox1.SetFocus
UserForm4.ComboBox1.DropDown
End Function

 

[jasonb75]

Check the tab index for each of the objects in the form. The default order is the order in which you added them to the form regardless of the form layout.

TabIndex 0 is the default focus when the form is opened, from there each press of tab / enter will move to the next object based on the index number.