View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neal Zimm Neal Zimm is offline
external usenet poster
 
Posts: 345
Default Navigate a worksheet when under control of a macro....

i guess i'm an advanced novice when it comes to VB.
I've coded a number of input boxes where various selections are made,
and actions taken based on the input.

I have a need for a user to get to different places in a worksheet when
"under the control" of an input box, before the "real data" is input. (no
need for scrolling left or right)

having them enter p1 to go towards the top 1 page, or p-1 for the opposite
seems a little excessive. same for entering a row number, soooooo

Is there a way to bring the "page up" and "page down" keys, and the up and
down
arrows as input, when an input box is awaiting an answer?
I've seen nothing in Excel help, and the answer seems 'no' from what I've
read on this board.

Thanks.

--
Neal Z