Modeless UserForm

[pujo]

Running some vba calcs on a worksheet, I have a userform with an image and label "Please Wait"

When executing the calcs subroutine, the userform is called but it takes a few saecond for the userform to show the image and label, the window window is visible.
I have the load statement before the show but still the same issue.

Public Sub UserForm_Initialize()
    Load frmWait
    frmWait.Show vbModeless
End Sub

Is there a method of waiting for the "Load" state of the userform before showing?

Similar to the method of the calculation state?
If Not Application.CalculationState = xlDone Then DoEvents

I have looked on the web but haven't found anything pertaining to the state of a userform.

Thanks!

 

[breynolds0431]

Instead of using another userform, would it be feasible to use a "Please Wait" label over the main userform? The label could be positioned out of the main UF window and when needed, its Left property appropriately set so that it's viewable. Or, the visible property could be set to False on UF initialize and then changed to True when needed.

Just a thought about avoiding using another UF.

 

[pujo]

Thanks for the reply,
What I ended up doing was adding a wait time of 1 sec and all worked fine.