View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_419_] Leith Ross[_419_] is offline
external usenet poster
 
Posts: 1
Default Control Scroll bar


Hello Mcroozer,

Here are the macros to move the scrollbar up and down.
____________________________


Code:
--------------------
[color=blue]
Sub ScrollUp()

Dim Y As Long

Y = Application.ActiveWindow.ScrollRow
If Y 1 Then
Application.ActiveWindow.ScrollRow = Y - 1
End If

End Sub

Sub ScrollDown()

Dim Y As Long

Y = Application.ActiveWindow.ScrollRow
If Y < 65536 Then
Application,ActiveWindow.ScrollRow = Y + 1
End If

End Sub
_____________________________

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=495819