Screen still changes. Why ? (Application.Screenupdating = False not working

  • Thread starter Thread starter Coza
  • Start date Start date
C

Coza

I have a Userfrom displayed upon the press of a button,

Sub Button10_Click()
Application.ScreenUpdating = False
UserForm4.Show
Application.ScreenUpdating = True
End Sub

BUT the page still changes why?
I also have the Application.Screenupdating = false included in the
Userfor4.Activate event too.

Corey....
 
Corey.
Application=Excel
Userform=VBA

Not sure what you are hoping to achieve, but you can Load a userform without
..Showing it

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing data between Userforms 1
Excel Code to run ActiveWindow.View in normal view, only runs manually. 21
Run two macros for two different sheets 11
Object variable or with Block variable not set 9
Worksheet Change Event macro fails intermittently 6
ScreenUpdating = FALSE 2
Suppressing a screen 2
How to resovle Screen Flickering 1

Back
Top