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 36 37 38 39 40 41 42 43
| Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim Plage As Range
Dim Cel As Range
Dim ligne As Integer
Dim Taille_List As Integer
Taille_List = Nbre_Ligne
Set Plage = Range(Cells(7, 15), Cells((Taille_List + 6), 15))
'défini la plage sur laquelle le code doit passer
For Each Cel In Plage
If IsEmpty(Cel) Then
ligne = Cel.Row
If Cells(ligne, 13) = "Urgence" _
Or Cells(ligne, 13) = "Important" _
Or (Cells(ligne, 13) = "Intermédiaire" And Cells(ligne, 22) = "Urgence") _
Then
Cel = "Phase 1"
ElseIf Cells(ligne, 13) = "Intermédiaire" _
Then
Cel = "Phase 2"
ElseIf (Cells(ligne, 13) = "-NC-" And Cells(ligne, 22) = "Intermédiaire") _
Then
Cel = "Phase 3"
Else: Cel = "-NR-"
End If
End If
Next Cel
End Sub |
Partager