I want to import a file, for example, need a few minutes, during import will check whether the data is correct, I think in a window display similar information:

Import, please be patient,,,
Data error 1
Data error 2
,
,
,
The import is complete, please correct the wrong data

My method is to use the listbox userform, now find a mistake will add an item, but the problem is the above information is always displayed at the time of the import is complete together, instead of real-time display, please give directions, thank you.

CodePudding user response:

Simple approach seems to be in the loop, or need to be updated with a DoEvents statement, it will execute the process temporarily to the requirement of system to deal with some of the current wait for,