Wondering if someone could help.

What I am trying to do is to create some form of notification when a 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 box or something to come up showing the information in C3.

Is this possible?

Any help would be greatfully recieved.

Thank you.

Barry.

'-----------------------------------------------------------------
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)

"BarryT" <BarryT.27ujwa_1147692900.5316@excelforum-nospam.com> wrote in
message news:BarryT.27ujwa_1147692900.5316@excelforum-nospam.com...
>
> What I am trying to do is to create some form of notification when a
> 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 box
> or something to come up showing the information in C3.
>
> Is this possible?
>
> Any help would be greatfully recieved.
>
> Thank you.
>
> Barry.
>
>
> --
> BarryT
> ------------------------------------------------------------------------
> BarryT's Profile:
http://www.excelforum.com/member.php...o&userid=34449
> View this thread: http://www.excelforum.com/showthread...hreadid=542078
>

Thank you so much for your help :D