Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Conrad Evans   on Jan 19 In MS Office Category.

  
Question Answered By: Morris Hughes   on Jan 19

Bring up the ChartTest Excel Pgm and click on the button(top area of the chart).
Sub StartTest()
Application.ScreenUpdating = True
UserForm1.Show
End Sub

This will display the UserForm panel w/command button.
The subroutine(TestChrt) is called inside the command button, which contains
only 3 lines of code.
Private Sub CommandButton1_Click()
Call TestChrt
End Sub

The purpose of this whole thing, is that everytime when selecting the button
(CommandButton1)
At completion( end ) of the code, there is this line of code...>
"Application.ScreenUpdating = True"
As a result of this, it causes the chart to flicker each time.
Try comment out this line and watch what happens.
NO Flicker at all, but slide the panel around some.
The panel images will repaint itself on top of the chart, because the
"Application.ScreenUpdating = True" is not executed.

What I would like to do, is to prevent the flickering of the Chart.
And also have the UserForm(panel) displayed without repainting itself when
sliding it around.

Sub TestChrt()
Application.ScreenUpdating = False
Sheets("TestChart").Select
Application.ScreenUpdating = True
End Sub

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Application.ScreenUpdating=TRUE - (TOUGH QUESTION!) Or get search suggestion and latest updates.