Some VBA questions mention the host application (e.g. Excel) is going "not responding" while their macro is running.
Is it ok to vote to close these questions as "broken code"?
If you don't do VBA, you probably don't know this, but most VBA host applications are single-threaded, and when VBA code runs for a long time it's completely normal that the main window's caption says "(not responding)" until the code completes.
So please stop downvoting and voting to close Excel/VBA questions as "broken code" whenever the OP mentions Excel going "not responding".
Thank you.
If the OP is only asking about why this is happening and how they can fix it, then they're not asking for a peer review and they're likely asking a question that should be on Stack Overflow, if they're not looking for feedback on any/all aspects of their code.
DoEvents
but that will slow down execution, not improve it. Asking "why is Excel not responding and how can I fix this?" is blatant SO territory IMO.
\$\endgroup\$
Jul 6, 2018 at 23:45