Bonjour le forum et une très bonne année 2014
Je reviens vers vous pour une formule ci dessous et j'aimerai la simplifier sachant que j'ai 450 cellules x 3
à proteger
Merci
Private Sub Worksheet_selectionChange(ByVal Target As Range)
If Target.Address(0, 0) = "E2" Then Range("G2").Select
If Target.Address(0, 0) = "E3" Then Range("G2").Select
If Target.Address(0, 0) = "E4" Then Range("G2").Select
If Target.Address(0, 0) = "E5" Then Range("G2").Select
If Target.Address(0, 0) = "E6" Then Range("G2").Select
If Target.Address(0, 0) = "F2" Then Range("G2").Select
If Target.Address(0, 0) = "F3" Then Range("G2").Select
If Target.Address(0, 0) = "F4" Then Range("G2").Select
If Target.Address(0, 0) = "F5" Then Range("G2").Select
If Target.Address(0, 0) = "F6" Then Range("G2").Select
If Target.Address(0, 0) = "J2" Then Range("G2").Select
If Target.Address(0, 0) = "J3" Then Range("G2").Select
If Target.Address(0, 0) = "J4" Then Range("G2").Select
If Target.Address(0, 0) = "J5" Then Range("G2").Select
If Target.Address(0, 0) = "J6" Then Range("G2").Select
End Sub
Je reviens vers vous pour une formule ci dessous et j'aimerai la simplifier sachant que j'ai 450 cellules x 3
à proteger
Merci
Private Sub Worksheet_selectionChange(ByVal Target As Range)
If Target.Address(0, 0) = "E2" Then Range("G2").Select
If Target.Address(0, 0) = "E3" Then Range("G2").Select
If Target.Address(0, 0) = "E4" Then Range("G2").Select
If Target.Address(0, 0) = "E5" Then Range("G2").Select
If Target.Address(0, 0) = "E6" Then Range("G2").Select
If Target.Address(0, 0) = "F2" Then Range("G2").Select
If Target.Address(0, 0) = "F3" Then Range("G2").Select
If Target.Address(0, 0) = "F4" Then Range("G2").Select
If Target.Address(0, 0) = "F5" Then Range("G2").Select
If Target.Address(0, 0) = "F6" Then Range("G2").Select
If Target.Address(0, 0) = "J2" Then Range("G2").Select
If Target.Address(0, 0) = "J3" Then Range("G2").Select
If Target.Address(0, 0) = "J4" Then Range("G2").Select
If Target.Address(0, 0) = "J5" Then Range("G2").Select
If Target.Address(0, 0) = "J6" Then Range("G2").Select
End Sub