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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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 Question
How do I create a Pop-up Notification/Reminder in Excel?
2 3 4
Replies
34
Views
4K
excelnewbie999
E
C
  • Question Question
Create code that sends emails and creates a log
Replies
1
Views
325
cokeoverpepsi123
C
F
  • Question Question
Send auto reminder to update a spreadsheet
Replies
3
Views
550
Kerryx
K
J
  • Locked
  • Solved
Reorder List VBA
Replies
3
Views
316
Peter_SSs
Peter_SSs
J
  • Question Question
Reorder list with formula or VBA
Replies
3
Views
356
Jlragr
J

Forum statistics

Threads
1,225,149
Messages
6,183,184
Members
453,151
Latest member
Lizamaison

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