Eliminate flickering

R

routeram

Hi all of you,

I have an excel sheet with around 200 data points and around 10 series
plotted in charts. I have buttons on the charts to invoke userforms.
Using scrollbars the user can change some parameters and see the change
on the charts. The problem is when I use the scrollbar, the charts
flicker while being updated.
I have tried turning off and on calculation and screen updating before
and after my code but it doesn't eliminate the flicker totally,
although it is reduced.

My code for a scrollbar is hardly a few lines. I just change the
corresponding cell in the data sheet.

Private Sub hsbV_DS_Change()
'Application.Calculation = xlCalculationManual
'Application.ScreenUpdating = False
wsData.Range("V_DS").value = hsbV_DS.value / 100
lblV_DS.Caption = hsbV_DS.value / 100
lblError.Caption = Range("Error_status")
'Application.Calculation = xlCalculationAutomatic
'Application.ScreenUpdating = True
End Sub

Any ideas are greatly appreciated. Thanks.

Regards,
Ram
 
N

N10

HI Routeram

You have to train your staff to blink in sequence with the flickering then
they wont notice it lol..just joking :)

I wondered could this be a hardware problem what type of system are you
using ?

Regards N10
 

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

Top