How to allow "Mouse Click" event or "switch Excel tab" when a macro is running - VBA?

[Samantha_Stone82]

I have a macro that extracts data from Microfocus RUMBA Mainframe Display and puts in Excel rows one after the other. I have created a Global Mainframe object and that is used for extraction to Excel. But when the process is running and if user decides to stop the processing he cannot click on Stop button on Excel or go to different tabs to see the data being pasted. He has to clicks like 6 times before tabs are switched or stopped.

I see that DoEvents allows mouse click events in the loop to do things but the code is written in a way that there is a lot of lines with in the loop and a function with no loop, and placing DoEvents after everyline seems irrational. I have a feeling there is a better to do that but not sure what that is. Can anyone please help?.

 

[Micron]

Ctrl+BREAK is supposed to stop code from running, but I haven't had much luck with that for many years. My laptop doesn't even have a break key, but it's supposed to have a shortcut key combination to replicate it. One click on a tab during a run is probably enough, but you'll have to wait until control returns to Windows. I think clicking 6 times isn't making a difference, but I could be wrong about that. Could also be that system resources are low when code is running?