Bonjour à tous
est-il possible de simplifier ce code? Merci
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
For i = 11 To 22
If Target.Address = "$F$" & i Then
Calendrier.Show
Cancel = True
End If
Next
For i = 11 To 22
If Target.Address = "$G$" & i Then
HrsMins.Show
Cancel = True
End If
Next
For i = 11 To 22
If Target.Address = "$H$" & i Then
HrsMins.Show
Cancel = True
End If
Next
For i = 11 To 22
If Target.Address = "$I$" & i Then
HrsMins.Show
Cancel = True
End If
Next
For i = 11 To 22
If Target.Address = "$J$" & i Then
HrsMins.Show
Cancel = True
End If
Next
If Target.Address = "$G$6" Then
Calendrier.Show
Cancel = True
End If
If Target.Address = "$F$30" Then
Calendrier.Show
Cancel = True
End If
End Sub