Private Sub Workbook_Open() For i = 2 To Sheet1.UsedRange.Rows.Count If (Sheet1.Cells(i, 2).Value = Date) Then Sheet1.Cells(i, 3).Value = "该合同到期拉" If (Day(Date) = Day(Sheet1.Cells(i, 2).Value)) Then MsgBox (Sheet1.Cells(i, 2).Value & "此合同已到期") End If Else Sheet1.Cells(i, 3).Value = "" End If Next i End Sub