ScrollBar is still activated when pressed 2 times in a row
 

I've seen this happen before with a Spinner from the "controls Toolbox"
(embedded control) ... so i presume/assume your's is an embedded control
too.

it takes focus intermittently...
and NO way you keep your cell selection.

I solved it by exchanging it for a "native" scrollbar
from "Forms" toolbar.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


0000_AAAA_0000 wrote :


I have a Scroll Bar:

Private Sub ScrollBar1_Change()
With ScrollBar1
Min = 1
Max = 30
LargeChange = 5
SmallChange = 1
End With
Range("A1").Select
End Sub


My problem comes because only once every to times I am eble to
accompliss this:
Range("A1").Select
Usually if I press the ScrollBar when Range("A1") is activated none
cell becomes activated the next time, the ScrollBar is activated.
and
if Range("A1") in this case is not selected the ScrollBar becomes
activated.

How can Avoid this and select Range("A1") every time????


Many thanks in advance!!