1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case ActiveCell.Value
Case "galva 1&2"
ActiveCell.Offset(rowOffset:=0, columnOffset:=1).Activate
With Selection.Validation
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=risque_galva1et2"
End With
Case "galva 3"
ActiveCell.Offset(rowOffset:=0, columnOffset:=1).Activate
With Selection.Validation
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=risque_galva3"
End With
Case "PVDF"
ActiveCell.Offset(rowOffset:=0, columnOffset:=1).Activate
With Selection.Validation
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=risque_PVDF"
End With
Case "Coex"
ActiveCell.Offset(rowOffset:=0, columnOffset:=1).Activate
With Selection.Validation
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=risque_coex"
End With
Case "Jacketting"
ActiveCell.Offset(rowOffset:=0, columnOffset:=1).Activate
With Selection.Validation
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=risque_Jacketting"
End With
End Select
End Sub |
Partager