David,

To use the arrow keys, you can't be within a macro. To acheive that, use Data Validation on each
cell, customizing the input message to be an appropriate prompt for each cell. Then you can use the
arrow keys, and get prompted.

HTH,
Bernie
MS Excel MVP


"cyberdude" wrote in message
oups.com...
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