Try this:
Create a subroutine called ScrollBar1_GotFocus by first selecting the sheet containing the scrollbar in the VBA Project Explorer window. In the right half of the screen, above the code section are 2 drop-down boxes. In the left hand box, select "ScrollBar1" then in the right hand box, select "GotFocus" This will create the subroutine definition for you. Now, simply add the following to that subroutine:
Selection.Select
When you click anywhere on the scrollbar (giving it focus), it will immediately give focus to whatever cell was previously selected when you release the mouse button.
Tony wrote:
How can I eliminate blinking scrollbars?
07-Feb-09
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
Previous Posts In This Thread:
How can I eliminate blinking scrollbars?
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
Hi,I'd start by tryingapplication.screenupdating=false'your codeapplication.
Hi
I'd start by tryin
application.screenupdating=fals
'your cod
application.screenupdating=tru
Mik
:
Didn't do anything. Still has focus, still blinking.Any other ideas???
Didn't do anything. Still has focus, still blinking
Any other ideas??? I appreciate any suggestions
Thanks
Tony
Tony,You can eliminate the thumb (the part that flashes) by settingthe
Tony
You can eliminate the thumb (the part that flashes) by settin
the LargeChange property to a value greater than the Max property
and setting the ProportionalThumb property to True
Of course that isn't always what you need, but other than setting th
focus elsewhere I am not aware of a way to keep it from flashing
--
Jim Con
Portland, Oregon US
"Tony" <
[email protected]>
wrote in message
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
Thanks, may have to settle for this.
Thanks, may have to settle for this. I had set the PropThumb property t
false so that the thumb was smaller and therefore less annoying. You
suggestion is better anyway
Thanks
Tony
Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Control?s Default Style or Template by Extending the WPF Designer in Visual Studio 2010
http://www.eggheadcafe.com/tutorial...g-the-wpf-designer-in-visual-studio-2010.aspx