如何在EXCEL表格中使用VBA设置一个当月最后一天自动提醒打印的信息框?

2025-03-06 20:49:05
推荐回答(1个)
回答1:

Private Sub Workbook_Open()
Dim lastday As Byte

lastday = Day(DateSerial(Year(Date), Month(Date) + 1, 0))
If Day(Now()) = lastday Then MsgBox "今天是本月最后一天,请打印"

End Sub