AW: Zeig mal Deinen Code...
12.03.2022 20:28:33
Ralph
dies ist die vollständige Prozedur:
Private Sub farbeBestimmen(sheetzahl As Integer)
Dim farbe As Integer
farbe = 10
anzahlds = ActiveWorkbook.Sheets(sheetzahl).Cells(Rows.Count, 1).End(xlUp).Row
For i = 3 To anzahlds
With ActiveWorkbook.Sheets(sheetzahl)
Debug.Print Format(CDate(Me.txtVon), "MM-DD-YYYY")
.Tab.ColorIndex = xlColorIndexNone
If .Cells(i, 1) >= CDate(Me.txtVon) And .Cells(i, 1) =" & Me.txtVon, Operator:=xlAnd, Criteria2:="=" & Format(CDate(Me.txtVon), "MM-DD-YYYY"), Operator:=xlAnd, Criteria2:="=" & Format(CDate(Me.txtVon), "MM-DD-YYYY"), Operator:=xlAnd, Criteria2:="=" & Format(CDate(Me.txtVon), "MM-DD-YYYY"), Operator:=xlAnd, Criteria2:="