Dim flag&(1 To 3)
Private Sub UserForm_Initialize()
Me.ComboBox1.List = [A1:A3].Value
Me.ComboBox2.List = [B1:B3].Value
Me.ComboBox3.List = [C1:C3].Value
End Sub
Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
key_tabpress ComboBox1, KeyCode, flag(1)
End Sub
Private Sub ComboBox2_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
key_tabpress ComboBox2, KeyCode, flag(2)
End Sub
Private Sub ComboBox3_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
key_tabpress ComboBox3, KeyCode, flag(3)
End Sub
Private Sub key_tabpress(combo As MSForms.ComboBox, ByVal KeyCode As MSForms.ReturnInteger, flag&)
With combo
If KeyCode = 9 And Val(flag) = 0 Then flag = 1: KeyCode = 0: .DropDown Else flag = 0
End With
End Sub