I have a VBA macro for Excel that may take a long time to process. In addition, in the beginning, I open another worksheet to get some data. While this is happening, nothing appears to be going on on the screen. I have a modeless userform that I want to display to indicate that processing is happening.
I'd like to put a command button on this userform that the user can click to stop the processing if they choose. The problem is that when the userform is displayed, if I move the cursor over it, the cursor is an hourglass, and clicking on the button does nothing.
Any suggestions?