Excel Alarm Clock

[MrIfOnly]

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

 

[Logit]

.
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 ?

 

[MrIfOnly]

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

 

[Logit]

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/share/agapEDwRtmHZv6vORkv6i1KAPfme6SAzbFlpFqd3oqg

Wonder is someone else has any ideas ?

 

[MrIfOnly]

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.

 

[guy999]

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

 

[MrIfOnly]

You're welcome. Thanks again for the feedback.

Regards,

CJ

 

[mandukes]

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

 

[MrIfOnly]

mandukes:

Thanks for the (much needed) ego boost!

Best regards,

CJ