AW: Fehler im Code ich komme nicht weiter
28.08.2018 15:11:54
Matthias
Moin!
Also arbeite an Stelle von ActiveCell mit Target. DAmit hast du gleich die geänderte Zelle. Am Anfang noch die Spalte prüfen, damit du auch die hast, mit einem Datum. Das würde dann so aussehen.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Current_Date As Date
Dim Date_String As String
If Target.Column 33 And Target.Column 34 Then Exit Sub
Date_String = Target.Value
Current_Date = CDate(Date_String)
Target.Value = Current_Date
If Target.Address = "$AG$1" Then
With Worksheets("AQW´s").Shapes("Oval 30").Fill.ForeColor
Select Case Target
Case Is >= (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is = (Current_Date)
.RGB = RGB(0, 250, 0) 'grün
Case Is
ggf. kann man auch die Prüfung unten zusammen fassen und in eine Schleife packen aber da sind bei AH die Shape 1 bis 3 nicht ein einer Reihe.
VG