Hi all,

i'm looking for getting alert msg in excel.
like the current date is 18/3/2007,and i want to get a alert message on
18/1/2007

Hi Rahesh,

'--------------------
i'm looking for getting alert msg in excel.
like the current date is 18/3/2007,and i want to get a alert message on
18/1/2007
'--------------------

Unless you can get time to go backwards, you are never likely to see the
alert!


However, try something like:

'=============
Private Sub Workbook_Open()
If Date = DateValue("18/01/2007") Then
MsgBox "Your alert message!"
End If
End Sub
'<<=============

This is workbook event code and should be pasted into the workbook's
ThisWorkbook module *not* a standard module or a sheet module:

Right-click the Excel icon on the worksheet
(or the icon to the left of the File menu if your workbook is maximised)
Select 'View Code' from the menu and paste the code.
Alt-F11 to return to Excel.


---
Regards,
Norman

By the way it may also be helpful to note that you can add helpful features
msgbox "Alert Text",vbcritical,"Reminder"

Just some extra, try buttons to add snooze funtionality as well

-John


"Norman Jones" wrote:


Hi Rahesh,

'--------------------
i'm looking for getting alert msg in excel.
like the current date is 18/3/2007,and i want to get a alert message on
18/1/2007
'--------------------

Unless you can get time to go backwards, you are never likely to see the
alert!


However, try something like:

'=============
Private Sub Workbook_Open()
If Date = DateValue("18/01/2007") Then
MsgBox "Your alert message!"
End If
End Sub
'<<=============

This is workbook event code and should be pasted into the workbook's
ThisWorkbook module *not* a standard module or a sheet module:

Right-click the Excel icon on the worksheet
(or the icon to the left of the File menu if your workbook is maximised)
Select 'View Code' from the menu and paste the code.
Alt-F11 to return to Excel.


---
Regards,
Norman