Hi, wonder if somebody can help me setup alert/message box based on date...
I have 17 sheets, each sheet is the same format... in H7 on each sheet, I have date, its date stamp when workscope is updates.
If possible, if H7 is within last 7 date, initiated alert popup message to a user, once sheet is open. Just want to alert user that sheet is update and they need to look for update at the bottom of the sheet... I start with code below but it does really work the way I need to. Any suggestion and help would be greatly appreciated.
Regards,Sub msgAlertWSupdate() With Sheets("Date") If .Range("H1").Value - Date < 7 Then MsgBox "This module have updated workscope, please see bottom of the page for update" & vbCrLf & "Update On:" & vbTab & .Range("K1").Value ") End If End With End Sub
Izet