excel repaint issue

[maswien]

I wrote a user form in excel, click a buton to run a query and then write the resultset to the sheet, then the form turns to be a blank for a while, can anybody tell me how to solve this problem?

 

[VBAjedi]

Your query may be slow. . . you could at least keep the screen from going blank by putting:

Application.ScreenUpdating = False

at the beginning of your code, and:

Application.ScreenUpdating = True

at the end of it. That way nothing would change until the code was finished running. . .

VBAjedi

 

[maswien]

thanks jedi,

I solved the problem by adding some doevents.