Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
required alert msg
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
required alert msg
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
required alert msg
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alert | Excel Discussion (Misc queries) | |||
How to Create Sound Alert and Email Alert when Macro is Finish | Excel Programming | |||
How to Create Sound Alert and Email Alert when Macro is Finish | Excel Programming | |||
How to Create Sound Alert and Email Alert when Macro is Finished | Excel Programming | |||
Pop-up Alert Help | Excel Programming |