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