Wondering if someone could help.

B

BarryT

What I am trying to do is to create some form of notification when
certain date is reached.

For Example:

There will be a date in Cell C4 and some information in Cell C3.

What I would like to happen is on the date specified in C4 a popup bo
or something to come up showing the information in C3.

Is this possible?

Any help would be greatfully recieved.

Thank you.

Barry
 
B

Bob Phillips

'-----------------------------------------------------------------
Private Sub Workbook_Open()
'-----------------------------------------------------------------
With Worksheets("Sheet1").Range("C4")
If .Value = Date Then
MsgBox .Offset(0, -1).Value
End If
End With
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Top