Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • 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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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