I have 4 ComboBoxes and a CommandButton.

If i click on each of them, everything behaves fine. However if i use the _KeyDown event to Tab or Enter to one of the other controls, that control disappears - it's still there, i just have to click anywhere on the worksheet, for it to reappear.


My code is as follows :

Private Sub ComboBoxEQOS_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = vbKeyTab Then ComboBoxRange.Activate
If KeyCode = vbKeyReturn Then CommandButtonB.Activate
End Sub