Excel Alarm Clock
Excel VBA Tools from Andrew
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Excel Alarm Clock

  1. #1
    Board Regular MrIfOnly's Avatar
    Join Date
    Nov 2016
    Location
    Wisconsin
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel Alarm Clock

     
    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_f8zqv...arm_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
    *************************************************
    Rate Schedule:

    • Answers: $1
    • Correct Answers: $2
    • Dumb looks are still free.

    *************************************************

    Want to make your listbox column widths adjustable? Take a look at this YouTube video and this sample file on RoryA's informative website: Tips and tricks | Excel Matters

  2. #2
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    31,879
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Excel Alarm Clock

    Quote Originally Posted by MrIfOnly View Post
    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_f8zqv...arm_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)?
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  3. #3
    Board Regular MrIfOnly's Avatar
    Join Date
    Nov 2016
    Location
    Wisconsin
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Alarm Clock

    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
    *************************************************
    Rate Schedule:

    • Answers: $1
    • Correct Answers: $2
    • Dumb looks are still free.

    *************************************************

    Want to make your listbox column widths adjustable? Take a look at this YouTube video and this sample file on RoryA's informative website: Tips and tricks | Excel Matters

  4. #4
    Board Regular MrIfOnly's Avatar
    Join Date
    Nov 2016
    Location
    Wisconsin
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Alarm Clock

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

    https://www.dropbox.com/s/7qjrctr2hy...lock.xlsm?dl=0

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

    Regards,

    CJ
    *************************************************
    Rate Schedule:

    • Answers: $1
    • Correct Answers: $2
    • Dumb looks are still free.

    *************************************************

    Want to make your listbox column widths adjustable? Take a look at this YouTube video and this sample file on RoryA's informative website: Tips and tricks | Excel Matters

  5. #5
    Board Regular MrIfOnly's Avatar
    Join Date
    Nov 2016
    Location
    Wisconsin
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Alarm Clock

    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.
    *************************************************
    Rate Schedule:

    • Answers: $1
    • Correct Answers: $2
    • Dumb looks are still free.

    *************************************************

    Want to make your listbox column widths adjustable? Take a look at this YouTube video and this sample file on RoryA's informative website: Tips and tricks | Excel Matters

  6. #6
    Board Regular
    Join Date
    Nov 2014
    Location
    South Africa
    Posts
    212
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Alarm Clock

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

  7. #7
    Board Regular MrIfOnly's Avatar
    Join Date
    Nov 2016
    Location
    Wisconsin
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Alarm Clock

    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.
    *************************************************
    Rate Schedule:

    • Answers: $1
    • Correct Answers: $2
    • Dumb looks are still free.

    *************************************************

    Want to make your listbox column widths adjustable? Take a look at this YouTube video and this sample file on RoryA's informative website: Tips and tricks | Excel Matters

  8. #8
    Board Regular Scott T's Avatar
    Join Date
    Dec 2016
    Posts
    2,015
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Excel Alarm Clock

    I downloaded it and it works but when I close the file it resizes Excel window. Running Office 365.
    Colonel Sandurz: Prepare ship for light speed.
    Dark Helmet: No, no, no, light speed is too slow.
    Colonel Sandurz: Light speed, too slow?
    Dark Helmet: Yes, we're gonna have to go right to ludicrous speed.

  9. #9
    Board Regular MrIfOnly's Avatar
    Join Date
    Nov 2016
    Location
    Wisconsin
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Alarm Clock

    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
    *************************************************
    Rate Schedule:

    • Answers: $1
    • Correct Answers: $2
    • Dumb looks are still free.

    *************************************************

    Want to make your listbox column widths adjustable? Take a look at this YouTube video and this sample file on RoryA's informative website: Tips and tricks | Excel Matters

  10. #10
    New Member
    Join Date
    Nov 2017
    Posts
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Alarm Clock

      
    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

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com