Unsorted

Prevent Not Responding in VBA

Nicholas Wong

Nicholas Wong

Prevent Not Responding in VBA

To prevent your program from not responding in VBA, add DoEvents to anywhere you might have a lot of data to process. This command could let txtStatus massages to be displayed normally. Otherwise, you will get the windows frozen and “not responding” while CPU keeps on busy since contents in txtStatus will not be refreshed!

Public Sub FileTester()  
    Do While True  
        '…  
        DoEvents  
        '…  
    Loop  
End Sub

Read more