Date Flag/Trigger

M

Music Non Stop

Hi there

I want my excel spreadsheet to flag up in some way when a particular date is
met. Basically I need to pre-order items and what the spreadsheet to notify
me when the pre-specified pre-order date arrives. Does anyone know a way of
doing this?

Thanks
Phil
 
B

Bob Umlas

You can do this in the workbook_open event:
Right-click the excel logo near the file menu, choose View Code, paste this
in (change the date to be what you want):
Private Sub Workbook_Open()
If Date >= #9/20/2003# Then MsgBox "yada yada"
End Sub

Bob Umlas
Excel MVP
 
Top