Simple (hopefully) DoEvents Question

[JeffK627]

If Application.ScreenUpdating is set to False, will DoEvents override it and cause the screen to be updated anyway?

 

[JeffK627]

8 views and no answers? Really?

 

[John_w]

I think not, because DoEvents is nothing to do with screen updating. From the VB Help:

"Yields execution so that the operating system can process other events.

DoEvents passes control to the operating system. Control is returned after the operating system has finished processing the events in its queue and all keys in the SendKeys queue have been sent."

 

[Norie]

I suppose it could, depending on what events are being done.

You don't mention what is being done, so hard to tell.

PS That might be why there weren't many responses.

 

[dk]

You can test it fairly easily. Run the test procedure - the screen doesn't update even though Doevents is called.

Sub test()

    Dim r As Long, c As Long
    Application.ScreenUpdating = False

    For r = 1 To 20

        For c = 1 To 20


            Cells(r, c) = Int(Rnd() * 1000)
            waitabit


        Next c

    Next r


Application.ScreenUpdating = True


End Sub

Sub waitabit()
    Dim t As Single

    t = Timer

    While Timer < t + 0.01
        DoEvents
    Wend
End Sub

 

[dk]

8 views and no answers? Really?

And please don't post things like this - you're not paying for our services so don't act like you are.