How to Set reminder in excel 2003?

F

friendlydue2000

Board Regular
Joined
Jul 31, 2010
Messages
94
Hi Everyone,

I need a small help, would appreciate if its quick!!!

Problem Statement:

We use excel 2003 spreadsheet for updating information. We would like to have a pop up message appearing or any thing which serves as a reminder.

The Reminder which we would like to set, is that every hour we need a pop up in excel informing/reminding us to " Download the Report for this hour".Alike feature in MS Outlook.

Awaiting a positive reply

Thanks

Regards
friendlydue2000
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
Can I ask why you aren't using the mentioned feature in Outlook itself?
 
Upvote 0
And why not let the Excel do the download every hour? Instead of only warning the user?
In VBA it's not that hard to check the time and perform an action at that time?

Mathijs.

Edit:
Here you can find your information:
http://www.ozgrid.com/Excel/run-macro-on-time.htm


Let's now suppose you want to run this macro (MyMacro) at 15 minute intervals after opening your Workbook. Again we will kick it off as soon as the Workbook Opens so right click on the Excel icon next to "File" and select "View Code". In here put;

Rich (BB code):
Rich (BB code): 
Private Sub Workbook_BeforeClose(Cancel As Boolean
Application.OnTime dTime, "MyMacro", , False
End Sub



Rich (BB code): 
Private Sub Workbook_Open()
Rich (BB code): 
Application.OnTime Now + TimeValue("00:15:00"), "MyMacro"
End Sub
</PRE>Now in any Standard Module (Insert>Module) place this;

Rich (BB code): 
Public dTime As Date
Sub MyMacro()
dTime = Now + TimeValue("00:15:00")
Application.OnTime dTime, "MyMacro"
'YOUR CODE

End Sub
</PRE>
 
Last edited:
Upvote 0
Hi

I have inserted the codings!!! But the Macro aint working at all. i do not get a pop up after interval of 15 minutes.

I am not getting any error messages too. So i do not know wat is gone wrong

Could you kindly recheck once and let me know

Thanks
 
Upvote 0
Hi Friendly,

Mr. Excel prefents me from making edits after 10 minuts... so I haven't written everything I wanted to ^^

To complete it, how long do you want it to be apart? I will set it on 1 hour as you stated in your first post.

Code: 
Private Sub Workbook_BeforeClose(Cancel As Boolean
Application.OnTime dTime, "MyMacro", , False
End Sub
 
Private Sub Workbook_Open()
Application.OnTime Now + TimeValue("01:00:00"), "MyMacro"
End Sub

Now in any Standard Module (Insert>Module) place this;

Code: 
Public dTime As Date
Sub MyMacro()
dTime = Now + TimeValue("01:00:00")
Application.OnTime dTime, "MyMacro"
msgbox "Please make your backup"
End Sub

I assume you know were to enter the different codes?

Greetings Mathijs.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
How do I create a Pop-up Notification/Reminder in Excel?
2 3 4
Replies
34
Views
2K
excelnewbie999
E
F
  • Question
Send auto reminder to update a spreadsheet
Replies
3
Views
393
Kerryx
K
A
  • Question
VBA for Outlook reminders
Replies
1
Views
596
Micron
M
O
  • Question
Excel/VBA to conditionally send emails per schedule
Replies
0
Views
699
OC2PS
O
H
  • Solved
Insert blank rows conditionally
Replies
3
Views
266
kevin9999
K

Forum statistics

Threads
1,215,059
Messages
6,122,918
Members
449,094
Latest member
teemeren

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top