An Analog Clock Model – video preview This is a video preview of the analog clock series which include a model section and a tutorial section. [sociallocker][/sociallocker]
One Reply to “An Analog Clock Model – video preview”
Thanks for such an interesting site. And opening people’s eyes to what can be achieved with Excel.
When I first saw your working analog clock, I thought great as I’ve been wanting one of these for years. I tried another one I found online that calculated the clock hand positions with VBA, however it froze after several hours of use (memory leak?).
Unfortunately your clock also freezes somewhere between 3 hours and 6 hours depending on resources available. The in-cell calulations for the clock hand positions continue to operate for many hours but the charts freeze up and only partly display or don’t display at all and Excel has to be shut down with Ctrl-Alt-Del.
I’ve tried it on multiple machines running Windows 7 and Excel 2007 all with the same result.
Do you know of any way to prevent this from happening?