Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to resovle Screen Flickering
How do I get reed of the screen flickering whenever I click on the button
that run this Sub. Private Sub cmdNLP3_Click() Application.ScreenUpdating = False Me.Range("C4,C41") = Me.cmdNLP3.Caption Me.Range("K8") = Evaluate("=VLOOKUP(H4,SiteCounts,9,FALSE)") Me.Range("K14") = Evaluate("=VLOOKUP(H4,SiteCounts,10,FALSE)") ''''**** REGIONAL SECTION ****'''' Me.Range("K45") = Evaluate("=SUM('Goals Tracker'!I107:'Goals Tracker'!I116)") Me.Range("K51") = Evaluate("=SUM('Goals Tracker'!J107:'Goals Tracker'!J116)") Me.Calculate Application.ScreenUpdating = True End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to resovle Screen Flickering
Hi Ayo,
Just a guess on my part, you have: Application.ScreenUpdating = False Application.ScreenUpdating = True Which should take care of the flickering. My question what does this do? ''''**** REGIONAL SECTION ****'''' If this represents a call to some other code that runs and does not have the updating=false/true, that may be where the flickering is occuring. The code will then return to this line of the original code and finish with no updating=false which may also produce flickering. Me.Range("K45") = Evaluate("=SUM('Goals Tracker'!I107:'Goals Tracker'!I116)") Otherwise I don't know. HTH Regards, Howard "Ayo" wrote in message ... How do I get reed of the screen flickering whenever I click on the button that run this Sub. Private Sub cmdNLP3_Click() Application.ScreenUpdating = False Me.Range("C4,C41") = Me.cmdNLP3.Caption Me.Range("K8") = Evaluate("=VLOOKUP(H4,SiteCounts,9,FALSE)") Me.Range("K14") = Evaluate("=VLOOKUP(H4,SiteCounts,10,FALSE)") ''''**** REGIONAL SECTION ****'''' Me.Range("K45") = Evaluate("=SUM('Goals Tracker'!I107:'Goals Tracker'!I116)") Me.Range("K51") = Evaluate("=SUM('Goals Tracker'!J107:'Goals Tracker'!J116)") Me.Calculate Application.ScreenUpdating = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flickering screen while processing macro | Excel Programming | |||
Blinking/flickering screen | Excel Discussion (Misc queries) | |||
screen flickering | Excel Programming | |||
FLICKERING SCREEN WHEN WORKING | Excel Discussion (Misc queries) | |||
Flickering of the Screen when the Macro runs. | Excel Programming |