Kann man irgendwie machen dass der Blattname in der Userform erscheint, in dessen am jeweils heutigen Tag (nach Datum) noch kein Eintrag in der Zeile steht?
https://www.herber.de/bbs/user/77081.xls
Küsschen Manuela
Private Sub UserForm_Initialize()
Label3.Caption = ActiveSheet.Name
End Sub
Sub Manuela()
Dim x&
MyDay = Format(Day(Date), "00")
mytext = ""
For x = 1 To Worksheets.Count
With Worksheets(x)
If WorksheetFunction.CountA(.Range(.Cells(MyDay + 2, 2), .Cells(MyDay + 2, 6))) = 0 Then
mytext = mytext & " " & .Name > "Chef"
End If
End With
Next
End Sub
Aber es steht nun "Falsch" in der Userform
Sub Manuela()
Dim x&
MyDay = Format(Day(Date), "00")
mytext = ""
For x = 1 To Worksheets.Count
With Worksheets(x)
If WorksheetFunction.CountA(.Range(.Cells(MyDay + 2, 2), .Cells(MyDay + 2, 6))) = 0 Then
mytext = mytext & " " & .Name > "Chef"
End If
End With
Next
End Sub
Sub Manuela()
Dim x&
MyDay = Format(Day(Date), "00")
mytext = ""
For x = 1 To Worksheets.Count
With Worksheets(x)
If .Name "Chef" Then
If WorksheetFunction.CountA(.Range(.Cells(MyDay + 2, 2), .Cells(MyDay + 2, 6))) = 0 Then
mytext = mytext & " " & .Name 'Orginal
End If
End If
End With
Next
End Sub
Gruß Matthias