Navigation Buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create navigation buttons ie........Up,Down,Left,Right. How can I tell (in vba)when i am at the very top of the page or at the very bottom. The buttons work fine but when i get to the top the buttons want to keep moving up everytime I press the "UP" button. If there was some command that said "Yes you are at the top" or "Yes you are at the bottom" then I could do an If Then statement to correct this

Thanks
dcstech
 
If by "at the top" you mean that row 1 is visible then you can check that
with:

If ActiveWindow.ScrollRow = 1 Then ...

It could get more complicated though if say row 1 is hidden.

--
Jim Rech
Excel MVP
|I am trying to create navigation buttons ie........Up,Down,Left,Right. How
can I tell (in vba)when i am at the very top of the page or at the very
bottom. The buttons work fine but when i get to the top the buttons want to
keep moving up everytime I press the "UP" button. If there was some command
that said "Yes you are at the top" or "Yes you are at the bottom" then I
could do an If Then statement to correct this.
|
| Thanks,
| dcstech
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
ViewSonic VX2758A-2K-PRO-3 Gaming Monitor with 2K and 240Hz Unboxing 2
URGENT help needed for a macro to place and size command button 7
macro to show / hide grouping, linked to label button 3
form buttons on sheet collapse on unhide - sometimes 5
Freeze section of worksheet to show on all other worksheets 2
Mid column sum formulas with varied ranges to sum 17
Oversensitive touchpad on modern laptops 0

Back
Top