Userform occasionally crashes Excel upon calling

[smallxyz]

My "Personal.xlsb" contains a Userform, which comprises lots of command buttons to handle different daily tasks. Long time ago I have created a quick-access icon on top-left corner of Excel toolbar, in order to invoke it more quickly via shortcut "Alt + 1". Such way of calling this Userform has been perfectly well for me for over 2+ years.

But recently, when using "Alt + 1" to show up the Userform, the whole Excel freezes itself and seems to hang and malfunction（See attached image 1）. Upon pressing "Ctrl + Break" to terminate the VBA code, Excel does respond but only to show up a freezing VBE screen （See attached image 2）. Any clicking to close, maximize, minimize the Excel windows is in vain. What I could do is to "Ctrl + Alt +Delete" to kill the "Excel.exe" to restart. The weirdest part is that, sometimes the Userform can successfully be invoked to show up, and those command buttons can still function properly. But sometimes it just screws up and hangs the whole Excel.

I note that this problem always arises when my PC has been running for a long time. Already tried re-install Office Excel. Not working. Extremely clueless.

Help.

* PC︰Windows 10 Home Edition, 64-bit
* Excel︰Microsoft Office LTSC 2021 Professional Plus



image 1︰

image 2︰

 

[RoryA]

As you should well know by now:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Userform occasionally crashes Excel upon calling

My "Personal.xlsb" contains a Userform, which comprises lots of command buttons to handle different daily tasks. Long time ago I have created a quick-access icon on top-left corner of Excel toolbar, in order to invoke it more quickly via shortcut "Alt + 1". Such way of calling this Userform has...

chandoo.org

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Dan_W]

Hi - I see from the Chandoo forum that you seem to have come to some kind of conclusion on this, but I suspect that this is probably the result of a graphics memory leak. I used to get them when I was learning how to make graphics-related API calls, and didn't realise that I needed to 'clean up' after myself. It can accumulate over time (or even over a matter of seconds) and once it gets to a certain point - the things you describe and show in the screen capture start to happen and Excel crashes (eventually). Does that sound familiar?