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