Private Sub CommandButton1_Click()
If Range("R4") = "" Or Range("R6") = "" Or Range("R8") = "" Then
MsgBox ("Il manque des informations...!")
If Range("R4") = "" Then
Range("R4").Interior.ColorIndex = 6
Else
Range("R4").Interior.ColorIndex = 0
End If
If Range("R6") = "" Then
Range("R6").Interior.ColorIndex = 6
Else
Range("R6").Interior.ColorIndex = 0
End If
If Range("R8") = "" Then
Range("R8").Interior.ColorIndex = 6
Else
Range("R8").Interior.ColorIndex = 0
End If
Else
Range("R4").Interior.ColorIndex = 0
Range("R6").Interior.ColorIndex = 0
Range("R8").Interior.ColorIndex = 0
If Sheets("GDC 2022").Range("A7") = "" Then
Sheets("GDC 2022").Range("A7") = Now()
Else
ListObjects(1).ListRows.Add.Range(1, 1).Value = Now() '<---- Erreur d'exécution '9' a ce niveau
End If
End If
End Sub