PDA

View Full Version : Stopping or breaking userform or code causes VBA to flip through all userforms



MrRhodes2004
12-27-2016, 03:04 AM
Hey Y’all,

I have a workbook with many UserForms, Modules, and Sheets. When I am working in a module or form I will test to see if it does what I want. While stepping through or the form is waiting for user input, I will stop it or break it. Sometimes when I do this, the VBA screen will flip through most of the userforms and stop a random one or will end up in a random module. It does not return to the specific userform or module that I was working in.

Sometimes I will export all forms and modules and re-import all of them. Then the occurrences of the above is reduced for a while and then gradually gets worse.

Any idea what causes this? Any thoughts on how to prevent this?

Thanks.