Setting the scrollbar positon
 

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

Setting the scrollbar positon
 

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

--
- K Dales


"Raul" wrote:

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

Setting the scrollbar positon
 

This did the trick.

Thanks a bunch,
Raul

"K Dales" wrote:

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

--
- K Dales


"Raul" wrote:

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