Debutantedina
Nouveau membre
bonjour,
je ne comprends pas pourquoi ce code ne marche pas sur VBA alors que je l'ai deja utilisé sur une autre feuille !!!
le message signalé est objet requis. Merci d'avance
Option Explicit
[cpp]
Private Sub Worksheet_Change(ByVal target As Range)
Dim iSect As Range, i As Long
Set iSect = Intersect([E2:J200], target)
If iSect Is Nothing Then Exit Sub
With iSect
For i = 1 To .Cells.Count
Select Case LCase(.Cells(i))
Case "Adéquat"
.Cells(i).Interior.ColorIndex = 4
Case "Adéquat avec PA"
.Cells(i).Interior.ColorIndex = 8
Case "Non Adéquat Avec PA"
.Cells(i).Interior.ColorIndex = 12
Case "Non Applicable"
.Cells(i).Interior.ColorIndex = 16
Case "Efficace"
.Cells(i).Interior.ColorIndex = 20
Case "Efficace avec PA"
.Cells(i).Interior.ColorIndex = 24
Case "Non Efficace"
.Cells(i).Interior.ColorIndex = 25
Case "Non Testé"
.Cells(i).Interior.ColorIndex = 31
Case "Non Testable"
.Cells(i).Interior.ColorIndex = 34
Case "OUI"
.Cells(i).Interior.ColorIndex = 34
Case "ENCOURS"
.Cells(i).Interior.ColorIndex = 34
Case "NON COMMENCE"
.Cells(i).Interior.ColorIndex = 34
Case "SOLDE"
.Cells(i).Interior.ColorIndex = 34
Case Else
.Cells(i).Interior.ColorIndex = xlNone
End Select
Next
End With
End Sub
[/cpp]
je ne comprends pas pourquoi ce code ne marche pas sur VBA alors que je l'ai deja utilisé sur une autre feuille !!!
le message signalé est objet requis. Merci d'avance
Option Explicit
[cpp]
Private Sub Worksheet_Change(ByVal target As Range)
Dim iSect As Range, i As Long
Set iSect = Intersect([E2:J200], target)
If iSect Is Nothing Then Exit Sub
With iSect
For i = 1 To .Cells.Count
Select Case LCase(.Cells(i))
Case "Adéquat"
.Cells(i).Interior.ColorIndex = 4
Case "Adéquat avec PA"
.Cells(i).Interior.ColorIndex = 8
Case "Non Adéquat Avec PA"
.Cells(i).Interior.ColorIndex = 12
Case "Non Applicable"
.Cells(i).Interior.ColorIndex = 16
Case "Efficace"
.Cells(i).Interior.ColorIndex = 20
Case "Efficace avec PA"
.Cells(i).Interior.ColorIndex = 24
Case "Non Efficace"
.Cells(i).Interior.ColorIndex = 25
Case "Non Testé"
.Cells(i).Interior.ColorIndex = 31
Case "Non Testable"
.Cells(i).Interior.ColorIndex = 34
Case "OUI"
.Cells(i).Interior.ColorIndex = 34
Case "ENCOURS"
.Cells(i).Interior.ColorIndex = 34
Case "NON COMMENCE"
.Cells(i).Interior.ColorIndex = 34
Case "SOLDE"
.Cells(i).Interior.ColorIndex = 34
Case Else
.Cells(i).Interior.ColorIndex = xlNone
End Select
Next
End With
End Sub
[/cpp]