Bonjour voila je viens de faire un formulaire (voir ficher juin). Je voudrai savoir si c'est possible d'utiliser la touche tabulation pour valider mes choix au lieu du click.
Voici mes codes
Private Sub ComboBox1_Change()
Me.ComboBox1.RowSource = "A2:A" & [A65000].End(xlUp).Row
End Sub
Private Sub ComboBox2_Change()
Me.ComboBox2.RowSource = "B2:B" & [B65000].End(xlUp).Row
End Sub
Private Sub ComboBox1_DropButtonClick()
ComboBox2.ListIndex = ComboBox1.ListIndex
End Sub
Private Sub ComboBox2_DropButtonClick()
ComboBox1.ListIndex = ComboBox2.ListIndex
End Sub
Private Sub ComboBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByValShift As Integer)
If KeyCode = 13 Or KeyCode = 9 Then
ComboBox1.Select: ComboBox2.Activate
End If
End Sub
Merci pour votre aide
Voici mes codes
Private Sub ComboBox1_Change()
Me.ComboBox1.RowSource = "A2:A" & [A65000].End(xlUp).Row
End Sub
Private Sub ComboBox2_Change()
Me.ComboBox2.RowSource = "B2:B" & [B65000].End(xlUp).Row
End Sub
Private Sub ComboBox1_DropButtonClick()
ComboBox2.ListIndex = ComboBox1.ListIndex
End Sub
Private Sub ComboBox2_DropButtonClick()
ComboBox1.ListIndex = ComboBox2.ListIndex
End Sub
Private Sub ComboBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByValShift As Integer)
If KeyCode = 13 Or KeyCode = 9 Then
ComboBox1.Select: ComboBox2.Activate
End If
End Sub
Merci pour votre aide