Posts by Zeca

    I have a UserForm with a text box that receives the following macro:

    Private Sub txtDueDate_Change ()
    On Error Resume Next
    If CDate (txtDateToday) <= CDate (txtDueDate) Then
    txtStatus = "OK"
    Else: txtStatus.Value = Abs (DateDiff ("d", CDate (txtDateToday), CDate (txtDueDate)))
    End If
    End Sub

    What we should do, when we opening the worksheet, the column "P" in the worksheet be automatically update with date difference.