Setting the scrollbar positon

[Guest]

I'm using a scrollbar to allow a user to scroll through a scrolling chart
(courtesy of Andy Pope). I also have a code snippet that updates the
"Object.Max" property of the scrollbar when additional rows of data are
added.

ActiveSheet.Shapes("ScrollBar1").Select
With Selection
' .Object.Max = "last row" - "first row - 1 " - "offset"
.Object.Max = LastRowArray(11, 1) - 6 - ScrlngChrtOffset
End With

The question I have is, is there a property (something like ScrollRight) I
can use to set the scrollbar to the rightmost positon so that the user does
not have to physically move the scrollbar slider to the maxium right position
to see the latest data?

Thanks in advance,
Raul

 

[Guest]

To go all the way to the right:
ActiveSheet.ScrollBar1.Value = ActiveSheet.ScrollBar1.Max

 

[Guest]

This did the trick.

Thanks a bunch,
Raul

To go all the way to the right:
ActiveSheet.ScrollBar1.Value = ActiveSheet.ScrollBar1.Max