Slow UserForm

[Patrick C. Simonds]

I have this simple piece of code to close one UserForm and open another. The
problem is that UserForm2 does not unload before UserForm14 opens, and it
sits behind UserForm14 (partially visible) until UserForm14 is closed. This
works fine on my other 5 UserForms.

Any thoughts?



Private Sub CommandButton2_Click()

Unload UserForm2
UserForm14.Show

End Sub

 

[Doug Robbins - Word MVP]

How about throwing in a UserForm2.Hide

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Patrick C. Simonds]

I tried that as well, Also tried Application.ScreenRefesh before opening
UserForm14

 

[Patrick C. Simonds]

Thanks to anyone who may have considered a solution to my problem.

Turns out I had an unmatched Application.ScreenUpdating = False

 

[Perry]

Application.screenupdating = false
'code to close and open userforms here
application.screenupdating = true

--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE