Excel Alarm Clock

[MrIfOnly]

So, I made this alarm clock as mostly an exercise in VBA that turned into a nice little time-killer project for me. I'm sharing it here for all who want it:

https://www.4shared.com/file/K_f8zqvRei/Alarm_Clock.html

A few of its features:

• dual alarm
• adjustable snooze time
• adjustable update time
• set alarms as: buzzer (choose from any standard sound file), music library file, 'speak to me', or run macro.
• multiple color schemes
• dimmer
• select font of your choice
• full screen option
• 24 hour clock option
• snooze button countdown

I am not (nor will I be in the future) asking for any money, but I would be very appreciative of any and all feedback, comments, suggestions, criticisms and feature requests.

Regards,

CJ

 

[Rick Rothstein]

So, I made this alarm clock as mostly an exercise in VBA that turned into a nice little time-killer project for me. I'm sharing it here for all who want it:

https://www.4shared.com/file/K_f8zqvRei/Alarm_Clock.html

A few of its features:

• dual alarm
• adjustable snooze time
• adjustable update time
• set alarms as: buzzer (choose from any standard sound file), music library file, 'speak to me', or run macro.
• multiple color schemes
• dimmer
• select font of your choice
• full screen option
• 24 hour clock option
• snooze button countdown

I am not (nor will I be in the future) asking for any money, but I would be very appreciative of any and all feedback, comments, suggestions, criticisms and feature requests.

I click the link you posted and could not figure out which Download button was the one for your file and which was part of an ad. Why don't you set up an account on DropBox and post your file there (it will be much clearer to figure out how to download it there)?

 

[MrIfOnly]

I wasn't sure what you were talking about, Rick, until I turned off my ad-blocker. It looks like every download button on that site redirects to an ad site. I will upload this to Dropbox later tonight.

Thanks.

CJ

 

[MrIfOnly]

Okay...here is the link to the Dropbox file:

https://www.dropbox.com/s/7qjrctr2hylucti/Alarm Clock.xlsm?dl=0

Please let me know if you have any problems with this link.

Regards,

CJ

 

[MrIfOnly]

Well...not having heard any feedback on this yet, I'm not sure if anyone has tried it, but for those who have, I uploaded an updated version tonight. The new version fixes a couple of minor cosmetic issues, allows the user to set the clock background as a gradient or picture (via the normal Excel toolbars), and turns off screen updating if the clock is not the active workbook. This last change continues to check the time and alarms set, however, so still may cause conflicts with workbooks running macros utilizing a timer.

 

[DHayes]

HI,
I attempted this but unfortunately it does not work in the 64 bit version.

 

[MrIfOnly]

Thanks for the feedback. Sorry to hear it didn't work. Unfortunately, I don't have 64-bit version and I'm not sure exactly what would cause the issue between versions. Perhaps someone here well versed in 64-bit programming could take a look at the code.

 

[Scott T]

I downloaded it and it works but when I close the file it resizes Excel window. Running Office 365.

 

[MrIfOnly]

Thanks for the feedback Scott. I wasn't able to duplicate this but it doesn't entirely surprise me. I tried my best to keep the clock centered and properly zoomed on the display, but was never really satisfied with the result. I sort of settled for best result on the 3 computers that I tested it on. I thought I covered resizing issues in the Workbook_BeforeClose event, but by your report, I wasn't successful. Any thoughts/suggestions?

Regards,

CJ

 

[guy999]

Hi
Like the look and idea of this, but when i download and open after enable editing get this message.

Run time error 91
Object variable or with block variable not set

Any ideas how to fix, running
Microsoft office prof plus 2010 , 32 bit