About loop waiting

aspirinum

What does everyone do in a long waiting loop?

airelemental

DoEvents

aspirinum

Can DoEvents be used in nested loops to cause problems, such as the situation that the program is temporarily unresponsive and needs to be operated to continue running.

四不像君

Screen.MouseIcon = vbHourglass
When you're done:
Screen.MouseIcon = vbDefault

DoEvents words
The process of ensuring that control is given up with DoEvents cannot be called again by other code before the first DoEvents returns; otherwise, unpredictable results will be produced. In addition, if other applications may interact with this process in unpredictable ways, then do not use DoEvents, because you cannot give up control at this time.

aspirinum

I mean the program should continue to run normally, but it is not running. Click the interface to continue running. I wonder if it is caused by DoEvents

snowmanzf

Yes. DoEvents can cause this problem,四不像君said very clearly.

午夜修罗

What does "not running state appear" mean?
The function of DoEvents is to temporarily stop the execution of the statement under DoEvents of the current process or method, so that the system can process other message tasks in the message queue, and then return to the statement under DoEvents to continue execution after processing, without the need for people to manually click the interface!
Your problem should not be caused by DoEvents

star811

Use DoEvents with care

aacc11

What did everyone do in a long-waiting cycle?

1. Generally, the "progress bar" is used to remind the cycle of progress

2. Use do loop instead of for loop, add doevents in between

3. DoEvents can only appear once in a loop, and cannot be nested, otherwise an error occurs

dr8888

Whoever has problems using DoEvents, post the program code to see, how can this be said to be used carefully? ?
It's not that you can't use it! For loop == all kinds of improper use of statements will cause problems, should it be used carefully? ?
As long as the method is right, what will happen to DoEvents?
You can't call someone when DoEvents is paused. Even if the current procedure is called, it has no effect, just like a recursive function. Why can't you call yourself? ?
Answer: It won't work if it is wrong!