Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
...
Do
'Fire DoEvents every 100th iterations
If Counter mod 100 = 0 then
DoEvents
End If
'Exit sequence
If blnCancel Then
Goto Routine_Exit
End If
Loop Until [i]Done[/i]
...
Stars all round boys... I'm glad I thought of itstevexff said:Would DoEvents help at all? For example if you put a conditional DoEvents call in the middle of your loop to execute on every nth iteration, would it allow you to catch userform's MouseDown event, and maybe set a flag that could be checked inside the loop, allowing you to bail out early?