ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Audible Alarm Marco w/Pop-up Message (https://www.excelbanter.com/excel-programming/387002-audible-alarm-marco-w-pop-up-message.html)

JustWork

Audible Alarm Marco w/Pop-up Message
 
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

Audible Alarm Marco w/Pop-up Message
 
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

Bob Flanagan

Audible Alarm Marco w/Pop-up Message
 
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





All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com