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
"dcstech" wrote in message
...
|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