form show not filling in 1

[autex]

UserForm5.Show
Application.ScreenUpdating = False

userform5 is a form that say "downloading"
when info is downloading into spreadsheets

I don't know if application.ScreenUpdating = False is giving it time to load all the way, because the form comes up and is whited out

is there a way to delay application.ScreenUpdating = False until the form is filled?

 

[PHV]

You may try this:
UserForm5.Load
UserForm5.Show
DoEvents
Application.ScreenUpdating = False

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244