How to do the following by pressing the down arrow or up arrow key?

[cyberdude]

Hi,


I wrote a macro to do the following thing:

I move from B1 to B100 and for each stop over a B cell, an input box
prompts me to key in a number to be the value in the current B cell. I
press enter to move to the next cell. Then, an input box popps up
asking me for a number again. The process goes on until B100.

Now, I want to do a slightly different thing: I want to move up and
down the B cells casually and easily by pressing the down arrow or up
arrow key without pressing the enter key at all. Is it possible to do
that? Let me give you an example. Suppose, I am on B3. An input box
shows up and asks me for a number. I enter 3. I want 3 to be B3's
value, and I hope to move up one cell by pressing the up arrow key or
down one cell by pressing the down arrow key without using the enter
key at all. Is doing that possible? Thanks.

David

 

[Tom Ogilvy]

Look in Excel help at OnKey and sendkey. Define uparror to send a return
and move up one cell, down arror to send a return and move down one cell.

Untested suggestion, but the only thing I can think of.