Mimicking page up and page down

How can I have 2 buttons on Excel sheet which does page up and page down? Thanks.
teelingAsked:
Who is Participating?
 
javajwsConnect With a Mentor Commented:
ActiveWindow.LargeScroll down:=1 (pagedown)
ActiveWindow.LargeScroll up:=1 (pageup)

More info at:
http://www.mrexcel.com/forum/showthread.php?t=14263
0
 
teelingAuthor Commented:
So I now have 2 buttons on the Excel sheet. The codes work fine. When I click on the pagedown button, the whole sheet scrolls down, both the pageup and pagedown button moves all the way up. How can I let these 2 buttons float with the scrolling? Thanks.
0
 
javajwsCommented:
One option is to put the button in the top row and Freeze Pane for the top row.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
teelingAuthor Commented:
just figured that out.. do u know how to put the triangle picture on a command button?
0
 
javajwsCommented:
If you use the "Command Button (ActiveX Control)" not the "Button (Form Control)", you can right click the button, select Properties and set the Picture Property to any picture you want to.

The "Button (Form Control)", does not have the ability to have a picture on it.  Only text.
0
 
teelingAuthor Commented:
Got it. Thank you very much :)
0
All Courses

From novice to tech pro — start learning today.