LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to navigate through unprotected cells only in a worksheet VictorO New Users to Excel 2 October 24th 08 12:11 AM
Navigate in a big worksheet Rockbear Excel Discussion (Misc queries) 4 April 18th 08 04:02 PM
navigate in Excel worksheet without scrolling johnson.82 Excel Worksheet Functions 2 April 7th 05 03:55 PM
Navigate by macro Bob Phillips[_6_] Excel Programming 0 May 28th 04 04:39 PM
using hyperlinks to navigate around a protected worksheet Paul James[_3_] Excel Programming 0 November 19th 03 01:52 AM


All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"