View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How can I eliminate blinking scrollbars?

Hi,

I'd start by trying

application.screenupdating=false

'your code
application.screenupdating=true

Mike

"Tony" wrote:

I have a VBA from which uses scrollbars to scroll data through a grid of
text boxes (not associated with a frame or the form its self). The problem
is that when they get focus, they flash. Very Annoying!. I have not found
anyway to stop this, so I tried shifting focus to another control during the
Change event. This works if the Scrollbar value only changes once (single
click). If the user scrolls any longer, the value of the scrollbar
increases, but then it keeps the focus leaving the user with a blinking
scrollbar. Any thoughts?

Thanks for any help here...

Tony