Hello, I have a custom Userform which loads a loop that keeps a running clock on a label on the Userform. I have a shape on my sheet which I click to show the Userform. When the Userform initializes it sets a global variable called "Running" to True. In the Userform's Activate procedure I call the "timeAnimation" procedure (located in Module1) if "Running" is True. Closing the Userform sets "Running" to False.
Everything works fine when the Userform is loaded without moving the mouse, (Click the shape on the sheet, and then don't move the mouse until the Userform shows) but if I click the shape on the sheet to show the Userform, and then immediately move my mouse before the Userform shows, everything freezes and I have to use CTRL - BREAK to stop the "timeAnimation" loop which is freezing Excel.
I have tried adding a wait or sleep line in "timeAnimation" to allow the Userform to load before it starts the loop, this made no difference.
Any help is greatly appreciated!
Bookmarks