I don't think you can do much if you're really using an inputbox.

If you know where the user is supposed to be before you show the inputbox, you
could could do something first.

application.goto activesheet.range("a1"),scroll:=true
sometextvariable = inputbox(....)

If you're actually using a userform and you're using xl2k or higher), you could
show the userform like:

UserForm1.Show False
(modeless)

Which means that the user can click on the worksheet and change/scroll while the
userform is showing.

(It would seem like giant overkill to add scroll options to a userform, but I
bet you could do it!)

You could put a bunch of buttons (or even scrollbars) on a userform and assign
code like:

Private Sub CommandButton1_Click()
ActiveWindow.ScrollRow = ActiveWindow.ScrollRow + 1
End Sub




Neal Zimm wrote:

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

--

Dave Peterson