• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

Mimicking page up and page down

How can I have 2 buttons on Excel sheet which does page up and page down? Thanks.
0
teeling
Asked:
teeling
  • 3
  • 3
1 Solution
 
javajwsCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now