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

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.

JustWork wrote:

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

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

"JustWork" wrote in message
oups.com...
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