1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Value
Case "Agent": Enable_personel 2, Target
Case "Commis": Enable_personel 3, Target
Case "Comptable": Enable_personel 4, Target
Case "Directeur": Enable_personel 5, Target
Case "Technicien": Enable_personel 6, Target
Case "Supprimer": Target.ClearContents: Target.Interior.Color = xlNone: Target.ClearComments
End Select
End Sub
Private Function Enable_personel(index, cel)
With cel
.ClearComments
.Interior.Color = Sheets("codes").Cells(index, 1).Interior.Color
.AddComment: .Comment.Text Text:=Sheets("codes").Cells(index, 2).Text
End With
End Function |
Partager