Excel Alarm Clock - Page 2
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: Excel Alarm Clock

  1. #11
    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

     
    Hi guy999:

    Thanks for the feedback.

    Try this:

    From the ThisWorkbook module, click anywhere in the Workbook_Open sub, and then click run. That should set the missing object variable. Once this is done, save the workbook and try to reopen it.

    If you have your macro security settings set to disable macros with notification, then enable macros and then click on 'Settings' on the clock, then click 'Save & Exit' or 'Cancel' from the settings menu. This will also set the missing object variable.

    Please report back on how it works.

    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. #12
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    1,229
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Alarm Clock

    .
    Thank you MrIfOnly .

    With your instruction I was able to get the clock running. However, the display flickers constantly when changing seconds. Attempted to use Application.ScreenUpdating = False in various sections of the macro code but to no avail.

    Do you have any suggestions how to stop the flicker ?

  3. #13
    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

    Hey Logit:

    My display doesn't flicker, but the cursor does. If that's what you mean, I couldn't get around this either. However, I supplied the option to increase the amount of time between updates in the Settings menu. Go to Settings and increase the Update Time and see if that helps.

    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

  4. #14
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    1,229
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Alarm Clock

    I saw where changing the time to a higher sec. count will delay the flicker but ...

    Here is a download link so you can see what the display is doing. Keep in mind, the actual flicker is alot faster than what is shown in the video but just as visually distracting.

    https://www.amazon.com/clouddrive/sh...SAzbFlpFqd3oqg

    Wonder is someone else has any ideas ?

  5. #15
    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

    Wow...yeah, that's pretty bad. I'm not sure why that is happening and I haven't seen that on any of the computers I tested on.

    Thanks for posting this issue and sorry I don't have an immediate solution.
    *************************************************
    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. #16
    New Member
    Join Date
    Nov 2017
    Posts
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Alarm Clock

    Thank you MrIfOnly
    Got to work with macro settings, didn't need to open ThisWorkbook module.

    Works fine now thanks, but yes my cursor does flicker when updating but not the whole screen.

    Thanks for this


  7. #17
    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

    You're welcome. Thanks again for the feedback.

    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

  8. #18
    Board Regular
    Join Date
    May 2013
    Posts
    78
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Alarm Clock

    MrIfOnly

    Thank you so much for posting it, These projects are very helpful for understanding VBA programming to beginners as well as advance users. I really liked your project keep up the good work.

    Thank you so much once again

  9. #19
    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

      
    mandukes:

    Thanks for the (much needed) ego boost!

    Best 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

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