David,

Select a cell where, let's say, you want someone to enter their name. Choose Data / Validation...
then on the Settings tab, choose Text Length under Allow, and set it to a minimum of 1 using the
other boxes. Choose the "input message" tab, and type "Enter your name" in the message box, and
make sure that you check "Show input message when cell is selected"

Then in the cell below, do the same, except choose, let's say, Allow: "Whole Number" "Between"
Min: "1" and Max "10" (use the four boxes). Then on the input message tab, set the message to be
"Choose a number between one and ten"

Then when you arrow down between those cells, you will see the two input messages, and still be able
to arrow around....

HTH,
Bernie
MS Excel MVP


"cyberdude" wrote in message
oups.com...
Hi,

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.

Could you tell me more about Data Validation and the other steps in
your mind that may help me do the job? Thank you in advance.

David