Statement to force the application's screen to update

[Glory]

My code resizes my userform, reducing its height by half. Then my code lets application.screenupdating = false.

But when screenupdating becomes false, the lower half of the userform remains frozen on the screen.

Is there a statement to force Excel to update its display before the next line in the code is initiated? I tried DoEvents with no success.

 

[Glory]

I can use "Me.Repaint" userform. No luck. It's like no matter what I do, Excel runs through the resize statements so fast that once it reaches the screenupdating statement, it still hasn't redrawn the userform even if I specifically tell it to repaint before turning off screenupdating.

Tried a do loop to 1,000,000 and that has exactly the same results.

 

[Glory]

Application.Wait Now + TimeValue("00:00:01")
Application.ScreenUpdating = False
For i = 0 To 207 Step 20.7
    Label3.Width = i
    Label4.Caption = Int((i / 207) * 100) & "%"
    Application.Wait Now + TimeValue("00:00:01")
    Me.Repaint
    DoEvents
Next
Unload Me
[FONT=Times New Roman]Exit Sub[/FONT]

The first wait method comes between a series of resize and enabled/disabled statements that swap between two states on the same userform.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Without that first wait method, the userform appears in both states simultaneously when screenupdating becomes false; like catching a baseball flying on a camera with a low shutter-speed, the userform is distended and the newly-visible progress bar awkwardly overlaps the old frame.
<o> </o>
The second application wait method is important because without it the code runs so fast it’s impossible to observe the progress bar advancing. The doevents is critical because without it, the form does not update until the code finishes running.
<o> </o>
I only wish I could set the interval on Wait lower than one second. But that won’t matter for the final application, because it will be waiting several seconds between each update anyway, as the pivot tables are updated and the sheets print out.