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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>