Audible Alarm Marco w/Pop-up Message

[JustWork]

Hello,

I need to create a marco that will pop-up a text box indicating a task
needs to be completed every xMinutes after the hour and sound an
alarm.

I also need to have a macro that will pop-up a text box indicating a
task needs to be completed at a certain time every day and sound an
alarm.

All help is appreciated. If possible please provide VBA examples.

Thanks,

Paul

 

[Dave Peterson]

Chip Pearson explains how to use application.ontime:
http://www.cpearson.com/excel/ontime.htm

And John Walkenbach explains how to play sounds:
http://www.j-walk.com/ss/excel/tips/tip59.htm

Each has sample code at their sites.

 

[Bob Flanagan]

Paul, I found that Cute Reminder at http://www.cutereminder.com/ is much
better than using Excel for reminders.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel